test.java

在linux下测试mysql的java程序

import java.sql.*;
public class Test {
public static void main(String[] args) {
    String driver="com.mysql.jdbc.Driver;
                 

    String url="jdbc:mysql://127.0.0.1/student?user=root&password=a"; 
    Connection conn=null;
    Statement stmt=null;
    try{            
     Class.forName(driver);
                           

     conn=DriverManager.getConnection(url);
     stmt=conn.createStatement(); 
     stmt.executeUpdate("update student set studname='rr' where student='1'");  

     ResultSet rs=stmt.executeQuery("select * from student");  

rs.last();                           
 System.out.println(rs.getRow());
rs.beforeFirst();                    

System.out.println("success step 1"); 

while(rs.next())                      
{                                     
 System.out.println(rs.getString(2)); 
}

System.out.println("Hello Boy and Girl !");
  }catch(ClassNotFoundException e){     
     e.printStackTrace();
    }catch(SQLException e){
     e.printStackTrace();
    }
  

}

}