sql2005test.java

来自「用java实现的企业进销存管理系统」· Java 代码 · 共 52 行

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package sqltest;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author Administrator
 */
public class SQL2005test {
    protected static String dbClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	protected static String dbUrl = "jdbc:sqlserver://localhost:1433;"
			+ "DatabaseName=db_JXC";
	protected static String dbUser = "sa";
	protected static String dbPwd = "aBC13451286928";
        private static  Connection conn;
        private static ResultSet rs=null;
        private static Statement st=null;
        public static void main(String[] args) throws SQLException, ClassNotFoundException{
       
            try {
                Class.forName(dbClassName).newInstance();
                throw new InstantiationException();
            } catch (InstantiationException ex) {
                System.out.println("exception");
                Logger.getLogger(SQL2005test.class.getName()).log(Level.SEVERE, null, ex);
            } catch (IllegalAccessException ex) {
                Logger.getLogger(SQL2005test.class.getName()).log(Level.SEVERE, null, ex);
            }
            conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
            st=conn.createStatement();
            rs=st.executeQuery("select * from tb_gysinfo");
            if(rs!=null){
                while(rs.next()){
                    System.out.println(rs.getString("id"));
                }
            }
        }

}