JDBC 简单数据库操作

 1 package cose.seu.edu.cn.cosersoft;
 2 import java.sql.*;
 3 public class Test {
 4     /*
 5      * Create a connection to MYSQL database
 6      */
 7     public static Connection getConnection() 
 8         throws ClassNotFoundException, SQLException{
 9         String url="jdbc:mysql://127.0.0.1:3306/myDb";
10         Class.forName("com.mysql.jdbc.Driver");
11         String username="root";
12         String password="coser";
13         Connection conn = DriverManager.getConnection(url, username, password);
14         return conn;
15     }
16     public static void PrintResult(ResultSet rs) throws SQLException{
17         while(rs.next()){
18             System.out.println(rs.getInt(1));
19         }
20     }
21     public static void main(String [] args) throws Exception{
22         Connection conn = getConnection();
23         Statement sqlstate = conn.createStatement();
24         if(!conn.isClosed())
25             System.out.println("连接数据库成功");
26         else System.out.println("连接数据库失败");        
27         //Execute common sql text;
28         String sqltext = "select * from mytb";
29         ResultSet rs = sqlstate.executeQuery(sqltext);
30         PrintResult(rs);
31         sqlstate.close();
32         //Call procedure with no parameters
33         CallableStatement cs = conn.prepareCall("{call myPro()}");
34         rs=cs.executeQuery();
35         PrintResult(rs);
36         cs.close();
37         //Call procedure with parameters
38         CallableStatement cs2 = conn.prepareCall("{call pr_Add(?)}");
39         //add parameter
40         cs2.setInt(1, 1001);
41         cs2.execute();
42         System.out.println("Insert successfully!");
43         cs2.close();
44         conn.close();
45     }
46 }