mydb.java

来自「java编写程序」· Java 代码 · 共 47 行

package mydbproject;
import java.sql.*;

public class MyDB {
    public static void main(String[] args) {

        //加载驱动程序
        try {
            //桥连接
            //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            //直接连接
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ex) {
        	
        }

        //连接字符串
        //桥连接
        //String str = "jdbc:odbc:test";
        //直接连接
        String str = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=studb";
        try {
            Connection con = DriverManager.getConnection(str,"sa","sa");
            Statement sta = con.createStatement();
            ResultSet res = sta.executeQuery("select * from student");

            while(res.next()) {
                System.out.print(res.getInt(1));
                System.out.print(res.getString("s_name"));
                System.out.print(res.getString(3));
                System.out.println();
            }

            //sta.executeUpdate("insert into student(s_name,s_sex,s_add,s_email)" +
            //  "values('aaa',1,'aaa','[e-mail]')");

            res.close();
            sta.close();
            con.close();

        } catch (SQLException ex1) {
            ex1.printStackTrace();
        }
    }
}