java连接mysql 5.0代码

import javax.sql.*; /*需要注意的是下面三句话一定要明确写定是那个包中的那些类 *这样就不会与jdbc中的Connection等类产生调用模糊的问题 *另外还要注意的是那个mysql包一定要放在最顶部 */ import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import java.sql.PreparedStatement; import java.sql.*; import com.mysql.jdbc.*; ////import java.rmi.server.*; //import java.io; //import java.util.*; class A{ public static void main(String []arg) throws SQLException{ Connection cn = null; ResultSet rs = null ; Statement stat; String connectionUrl="jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=utf8"; String user="root"; String password="123000"; try{ Class.forName("com.mysql.jdbc.Driver"); System.out.println("OK,DownLoad the driver"); } catch(Exception e) { System.out.println("Error loading Mysql Driver!"); System.err.println(e.getMessage()); } cn = DriverManager.getConnection(connectionUrl,user,password); //下面是第二种方法 // cn=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=123000"); if (cn == null){ System.err.println("Connection failed..."); System.exit(0); } PreparedStatement prstat=cn.prepareStatement("INSERT INTO table1 (name) VALUES (?)"); prstat.setString(1,"龙"); prstat.executeUpdate(); stat = cn.createStatement(); rs = stat.executeQuery("select * from table1"); while(rs.next()){ String name =rs.getString("name"); System.out.println(name); } rs.close(); stat.close(); cn.close(); } }