package cn.ccsu;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
public class TestSql {
public static void main(String[] args) {
Statement stmt = null;
ResultSet rs = null;
Connection conn=null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn =
DriverManager.getConnection("jdbc:mysql://localhost/user1?" +
"user=root&password=1234");//
stmt = conn.createStatement();
rs = stmt.executeQuery("select *from classmates");
while(rs.next()){
//System.out.println(rs.getString("id"));//在calssmates中已经建立id这一项采可以操作
System.out.println(rs.getInt("id"));
}
}
catch (SQLException ex){
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch(NullPointerException e){
e.printStackTrace();
}
finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException sqlEx) {
sqlEx.printStackTrace(); } // ignore
}
rs = null;
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException sqlEx) {
sqlEx.printStackTrace(); } // ignore
stmt = null;
}
}
}