Á¬MySQLÊý¾Ý¿â

import java.sql.*;
import javax.resource.cci.ResultSet;
public class Temp{
public static void main(String[] args)throws Exception{
/*Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/test?user=root&password=hugh&useUnicode=true&characterEncoding=utf-8";*/

Class.forName("com.mysql.jdbc.Driver").newInstance();
String url ="jdbc:mysql://localhost:3306/test?user=root&password=hugh";

Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from student";
java.sql.ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.out.println("µÚÒ»¸ö×Ö¶ÎÄÚÈÝΪ£º"+rs.getString(1));
System.out.println("µÚÒ»¸ö×Ö¶ÎÄÚÈÝΪ£º"+rs.getString(2));
}
System.out.print("Êý¾Ý¿â²Ù×÷³É¹¦£¬¹§Ï²Äã");
rs.close();
stmt.close();
conn.close();
}
}