JDBC:灵活指定SQL中的变量（SXT）

 JDBC:灵活指定SQL中的变量（SXT）

 

Demo

1. import java.sql.*;
4. import com.sun.org.apache.xalan.internal.xsltc.runtime.Parameter;
6. public class TestPrepState
7. {
9.     /**
10.      * PreparedStatement的简单使用
11.      * 灵活指定SQL中的变量
12.      * 手动输入参数
13.      */
14.     public static void main(String[] args)
15.     {
16.         // TODO Auto-generated method stub
18.         if (args.length != 4)
19.         {
20.             System.out.println("Error,plesase input again!");
21.             System.exit(-1);
22.         }
24.         int userid = 0;
25.         try
26.         {
27.             userid = Integer.parseInt(args[0]);
28.         } catch (NumberFormatException e)
29.         {
30.             System.out.println("Number error");
31.             System.exit(-1);
32.         }
34.         String usernameString = args[1];
35.         String passwordString  = args[2];
36.         String userflaString = args[3];
38.         Connection conn = null;
39.         PreparedStatement pstmt = null;  
40.         //引用包的时候注意：这个PreparedStatement是java.sql中的，而不是com.mysql.jdbc中的那个PreparedStatement
41.         ResultSet rs = null;
43.         try
44.         {
45.             Class.forName("com.mysql.jdbc.Driver");
47.             String url = "jdbc:mysql://localhost:3306/college";
48.             String user = "root";
49.             String password = "123456";
50.             conn = DriverManager.getConnection(url, user, password);
52.             pstmt = conn.prepareStatement("insert into user values(?,?,?,?)");
53.             pstmt.setInt(1, userid);
54.             pstmt.setString(2, usernameString);
55.             pstmt.setString(3, passwordString);
56.             pstmt.setString(4, userflaString);
58.             
59.             pstmt.executeUpdate();
60.             
62.             rs = pstmt.executeQuery("select * from user where userId='"+userid+"'");
64.             while (rs.next())
65.             {
66.                 System.out.print("username:");
67.                 System.out.println(rs.getString("userName"));
68.                 System.out.print("password:");
69.                 System.out.println(rs.getString("userPassword"));
71.             }
73.         } catch (ClassNotFoundException e)
74.         {
75.             // TODO Auto-generated catch block
76.             e.printStackTrace();
77.         } catch (SQLException e)
78.         {
79.             // TODO Auto-generated catch block
80.             e.printStackTrace();
81.         } finally
82.         {
84.             try
85.             {
86.                 if (rs != null)
87.                 {
88.                     rs.close();
89.                     rs = null;
90.                 }
92.                 if (pstmt != null)
93.                 {
94.                     pstmt.close();
95.                     pstmt.close();
96.                 }
98.                 if (conn != null)
99.                 {
100.                     conn.close();
101.                     conn = null;
102.                 }
104.             } catch (SQLException e)
105.             {
106.                 // TODO Auto-generated catch block
107.                 e.printStackTrace();
108.             }
110.         }
112.     }
113. }