test.java

来自「用JSP做的 数据库和源代码绝对保真 欢迎大家交流使用」· Java 代码 · 共 66 行

package sql;

//package connectDBclass;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

//连接数据库类
public class test{
    static Statement st=null;
	static Connection con=null;
	static ResultSet rs=null;
	
	public test(){
		
		
	}
	
	//static public Statement conDB(){
	
	

	//}
	public static void main(String args[])
	{
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		}
		catch(ClassNotFoundException e)
		{
			JOptionPane.showMessageDialog(null,"数据库加载很失败!");
		}
		try{
			
			String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS";//数据库地址和服务端口号
			String user = "sa";
			String password = "5201314";
			Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
			String command="select * from admintable";
			st=con.createStatement();
			 rs=st.executeQuery(command);
             JOptionPane.showMessageDialog(null," 连接成功");
             while(rs.next())
             {
            	 int id=rs.getInt(1);
            	 String name=rs.getString(2);
            	 System.out .print("id:"+id);
            	 System.out.print("name:"+name);
             }
             rs.close();
             st.close();
             conn.close();
            

		}
		catch(SQLException ex)
		{
			JOptionPane.showMessageDialog(null,"数据库连接失败!");
		}
		//return st;
		 
		
		
	}
}