插入數(shù)據(jù)import java.sql.*;/** * @version 2012-02-22 * @author  */public class InsertDemo {    public static void main(String[] args) throws SQLException {        Connection conn = null;        Statement stmt = null;        String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";// 
        String connectDB="jdbc:sqlserver://localhost:1433;DatabaseName=JDBCTest";//
        String user="sa";        String pwd="sql";        try {            // 動(dòng)態(tài)導(dǎo)入數(shù)據(jù)庫的驅(qū)動(dòng)             Class.forName(JDriver);            // 獲取數(shù)據(jù)庫鏈接             conn = DriverManager.getConnection(connectDB,user,pwd);            // 創(chuàng)造SQL語句             String sql = "INSERT INTO JDBCTestTable ( user_name, user_passWord ) VALUES ( 'balabala', '123456' )";            // 執(zhí)行SQL語句             stmt = conn.createStatement();            stmt.executeUpdate(sql);            System.out.);        } catch (Exception e) {                e.printStackTrace();            stmt.close();            conn.close();        }    }}修改數(shù)據(jù)import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class UpdateDemo {    public static void main(String[] args) throws SQLException {        Connection conn = null;        Statement stmt = null;        try {            // 動(dòng)態(tài)導(dǎo)入數(shù)據(jù)庫的驅(qū)動(dòng)            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");            // 獲取數(shù)據(jù)庫鏈接            conn = DriverManager.getConnection(                    "jdbc:sqlserver://localhost:1433;DatabaseName=JDBCTest",                    "sa", "sql");            // 創(chuàng)造SQL語句            String sql = "UPDATE JDBCTestTable SET user_password = '456' WHERE user_name = 'Eric'";            // 執(zhí)行SQL語句            stmt = conn.createStatement();            stmt.executeUpdate(sql);            System.out.println("更新數(shù)據(jù)成功");        } catch (Exception e) {            e.printStackTrace();            stmt.close();            conn.close();        }    }}刪除數(shù)據(jù)import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;public class DeleteDemo {    public static void main(String[] args){        String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";        String url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JDBCTest";        String user="sa";        String password="sql";        try{            Class.forName(JDriver);// 動(dòng)態(tài)導(dǎo)入數(shù)據(jù)庫的驅(qū)動(dòng)            Connection conn=DriverManager.getConnection(url, user, password);// 獲取數(shù)據(jù)庫鏈接             String query="DELETE FROM JDBCTestTable WHERE user_name='Eric'";// 創(chuàng)造SQL語句             Statement stmt=conn.createStatement();// 執(zhí)行SQL語句            stmt.executeUpdate(query);            System.out.println("刪除數(shù)據(jù)成功");            stmt.close();            conn.close();        }catch(Exception e){            e.printStackTrace();        }    }}查詢數(shù)據(jù)import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class QueryDemo {    public static void main(String[] args){        String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";        String url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JDBCTest";        String user="sa";        String password="sql";        try{            Class.forName(JDriver);// 動(dòng)態(tài)導(dǎo)入數(shù)據(jù)庫的驅(qū)動(dòng)            Connection conn=DriverManager.getConnection(url, user, password);// 獲取數(shù)據(jù)庫鏈接             String query="SELECT * FROM JDBCTestTable";// 創(chuàng)造SQL語句             Statement stmt=conn.createStatement();// 執(zhí)行SQL語句            ResultSet rs=stmt.executeQuery(query);            while(rs.next()){                System.out.println(rs.getString("user_name")+":"+rs.getString(2));                //密碼字段的編號(hào)從1開始，密碼排第二位            }            System.out.println("查詢數(shù)據(jù)成功");            rs.close();            stmt.close();            conn.close();        }catch(Exception e){            e.printStackTrace();        }    }}