标准的写法:
。
package jdbc;
import java.sql.*;
标准的
public class Test1 {
public static void main(String[] args) {
Connection conn=null;
Statement stm=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/task","root","123456");
stm=conn.createStatement();
rs=stm.executeQuery("select * from student");
while (rs.next()){
int sid=rs.getInt("sid");
String gender=rs.getString("gender");
String sname=rs.getString("sname");
System.out.println(sid+" "+gender+" "+sname);
}
}catch (Exception e){
e.printStackTrace();
}finally {
if (rs!=null){
try{
rs.close();
}catch (SQLException e){
e.printStackTrace();
}
}
if (stm!=null){
try{
stm.close();
}catch (SQLException e){
e.printStackTrace();
}
}
if (conn!=null){
try{
conn.close();
}catch (SQLException e){
e.printStackTrace();
}
}
}
}
}