Á¬½ÓMySQLʱ³öÁËÎÊÌâ
ÎÒÊÇÓÃEclipseдµÄ£¬Çý¶¯ÒѾÕýÈ·µ¼ÈëÁË£¬ÎÒnewÁËÒ»¸öclassÎļþ¿ÉÒÔÕý³£ÔËÐÐ,µ«newÁËjspÎļþºó°Ñ¸Õ²ÅÄǸö¿ÉÒÔÔËÐеÄjavaÎļþÖеÄÊý¾Ý¿âÁ¬½Ó´úÂëcopy¹ýÀ´ºóÈ´ÔÚClass.forName("com.mysql.jdbc.Driver").newInstance();´¦±¨´í£¬²»ÖªµÀΪʲô£¬Ï£Íû¸÷λǰ±²¶à¶àÖ¸½Ì£¡
javaÎļþ´úÂëÈçÏ£º
import java.sql.*;
public class testMysql {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
ex.printStackTrace();
}
Connection conn =null;
Statement stmt = null;
ResultSet rs = null;
String name = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=");
stmt=conn.createStatement();
String sql = "select * from tb_user";
rs = stmt.executeQuery(sql);
if(rs.next()){
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......