jdbcÁ¬½ÓmysqlÎÊÌ⣬°ÝÍдó¼ÒÁË£¬ÅªÁËÒ»ÍíÉÏÁË
»·¾³ÎªEclipse£¬jdbcÇý¶¯Ò²¼ÓÔØÁË
ÎÒдÁ˸ö²âÊÔ£¬´úÂëÈçÏÂ
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.*;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.SQLException;
public class Test {
public void main(String []args)throws Exception
{
Class.forName("com.mysql.jdbc.Driver");
Connection con= DriverManager.getConnection(("jdbc:mysql://127.0.0.1:3306/test", "root", "123");
Statement sm=con.createStatement();
ResultSet rs=sm.executeQuery("SELECT * from wangpan");
while(rs.next())
{
System.out.println("UserId:"+rs.getString(0));
System.out.println("UserName:"+rs.getString(1));
System.out.println();
}
}
}
Connection con= DriverManager.getConnection(("jdbc:mysql://127.0.0.1:3306/test", "root", "123");
Statement sm=con.createStatement();
ÕâÁ½¾ä×ÜÊDZ¨´í¡£¡£¡£¡£Ëµtype mismatch: cannot convert from Connection to Connection
È¥µôÕâ¸öimport com.mysql.jdbc.Connection;
Ò»¸öÊÇimport com.mysql.jdbc.Connection;
Ò»¸öÊÇjava.sql.Connection;
¹þ¹þ£¬Â¥ÉÏÕý½â¡£¡£¡£
ÔÀ´ÒѾ¸ø³öÕýÈ·´ð°¸ÁË¡£
Χ¹ÛµÄ ¡£¡£¡£
·¹ýµÄ
¿ªÊ¼¿´£¬»¹Ïë½â½â£¬¿´×Å¿´×Å
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......
MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......