//连接数据库
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.*;
public class jdbctest //构造方法,初始化
{
private Connection conn; //连接对象
private Statement stmt; //语句对象
private ResultSet rs; //结果集对象
private static String user="sa"; //数据库用户名
private static String pwd="xbd"; //数据库密码
private static String URL="jdbc:sqlserver://localhost:1433;DatabaseName=OnLineExam"; //SQL Server驱动
程序字符串
public jdbctest()
{
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("Class操作数据库成功(加载驱动成功)!\n");
System.out.println("等待....\n");
conn = DriverManager.getConnection(URL, user, pwd);
System.out.println("conn操作数据库成功!");
}
catch(Exception e){
System.out.println("驱动加载成功,但未连接到数据库,请检查数据库服务是否开启");
}
}
public void setConn()
{
}
public Connection getConn(){
return conn;
}
/*获取Statement,只能用于
查询语句*/
public Statement getStmt()
{
//conn=getConn();
try{
conn=getConn();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//System.out.println("Statement操作数据库成功");
}
catch (Exception e){
System.out.println(e);
}
return stmt;
}
public void setStmt()
{
//return stmt;
}
/*获取ResultSet*/
public ResultSet getRs(String s)
{
stmt=getStmt();
try{
rs=stmt.executeQuery(s);
//System.out.println("ResultSet操作数据库成功");
// return rs;
}
catch(Exception e)
{
System.out.println(e);}
return rs;
}
public void setRs()
{
//return rs;
}
public void close()
{
try{
//rs.close();
stmt.close();
conn.close();
}catch(SQLException
sqlexception){
sqlexception.printStackTrace();
}
}
public boolean update(String sql)
{
Statement stm=getStmt();
try{
stm.executeUpdate(sql);
}
catch (Exception e){
System.out.println(e);
}
return true;
}
public static void main(String args[])
{
//SQL Server 服务器的端口号,默认为1433
jdbctest DBConn=new jdbctes
t();
//Connection conn=DBConn.getConnToMySql();
String sql="select * from tb_admin";
//String sql1="insert into username (uid,pwd) values('梦想年华','梦想年华')";
//stmt.executeUpdate(sql1);
ResultSet rs=DBConn.getRs(sql);
try{
System.out.println("栏目名称 选择的人数");
while(rs.next()){
System.out.print(rs.getString(1)+" ");
System.out.println(rs.getString(2));
}
rs.close();
//stmt.close();
DBConn.close();
}
catch(Exception e){
System.out.println("操作数据库出错,请仔细检查");
System.out.println(e);
}
}
}