JDBC使用Demo

 1 package com.dascom.xue;
 2 
 3 import java.sql.DriverManager;
 4 import com.mysql.jdbc.*;
 5 
 6 
 7 public class DBDemo {
 8 
 9     /**
10      * @param args
11      */
12     public static void main(String[] args) {
13         // TODO 自动生成的方法存根
14         
15         String url = "jdbc:MySQL://192.168.20.242:3306/test";
16         String user = "root";
17         String pwd = "test";
18         
19         try 
20         {
21             //加载驱动
22             Class.forName("com.mysql.jdbc.Driver");
23             //连接数据库
24             Connection conn =  (Connection) DriverManager.getConnection(url, user, pwd);
25             
26             if (!conn.isClosed())
27             {
28                 System.out.println("Connect DB success");
29             }
30             //创建执行sql的对象
31             Statement statment =  (Statement) conn.createStatement();
32             
33             String sql = "select * from wanbu_data_user where userid=7";
34             //执行sql并返回结果集
35             ResultSet rs = (ResultSet) statment.executeQuery(sql);
36             
37             while (rs.next())
38             {
39                 System.out.println(rs.getString("username"));
40             }
41             conn.close();
42         } catch (ClassNotFoundException e) {
43             e.printStackTrace();
44         }catch (Exception e1)
45         {}
46     }
47 
48 }