JDBC的连接例子!

1.连接sql2005的实例

方法1:往数据库中插入数据,创建一个java项目.创建一个class.

建立一个数据库test,创建表名为UserInfo(UserID,password)

使用PrepareStatment

package com.v512.example;import java.sql.*;import java.lang.*;public class JDBCExample {public static void main(String[] args) {String sql = "insert into UserInfo(UserID,password) values(?,?)";try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=test", "sa","123");PreparedStatement pStatement = con.prepareStatement(sql);pStatement.setString(1, "XXXXX");pStatement.setString(2, "101010");pStatement.executeUpdate();pStatement.close();con.close();} catch (Exception e) {// TODO: handle exception}}}

??2.使用statement插入数据

package com.v512.example;import java.sql.*;import java.lang.*;public class JDBCExample {public static void main(String[] args) {ResultSet rs = null;String sql = "insert into UserInfo(UserID,password) values('XXXXXXX','1010010101010')";try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=test", "sa","123");Statement statement=con.createStatement();    rs=statement.executeQuery(sql);    statement.close();    rs.close();} catch (Exception e) {// TODO: handle exception}}}

?

3.查询数据库的结果!

package com.v512.example;import java.sql.*;import java.lang.*;public class JDBCExample {public static void main(String[] args) {ResultSet rs = null;String sql="select * from UserInfo";try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=test", "sa","123");PreparedStatement statement=con.prepareStatement(sql);rs=statement.executeQuery();while (rs.next()) {System.out.println("name:"+rs.getString("UserID")+"\tpassword:"+rs.getString("password"));}          statement.close();          con.close();} catch (Exception e) {}}}

?