test.java

来自「综合测评管理系统——完成班级的综合测评工作」· Java 代码 · 共 42 行

import java.sql.*; 

public class Test {
public static void main(String[] srg) {
  String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  //加载JDBC驱动
  String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";  //连接服务器和数据库sample
  String userName = "sa";  //默认用户名
  String userPwd = "2005";  //密码

   
   Connection dbConn=null;
	 PreparedStatement ps=null;
	 ResultSet rs=null;
	 String usertype="";
	 String username="administrator";
	 try{
	 	Class.forName(driverName);
	 	}catch(Exception e){
	 		e.printStackTrace();
	 	}

	 try{
	 	
	 	dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
		String queryStr="select * from login WHERE username=?";
		ps=dbConn.prepareStatement(queryStr);
		ps.setString(1,username);
		rs=ps.executeQuery();
		if(rs.next())
		usertype=rs.getString("type");
		System.out.println(usertype);
	}catch(SQLException exc){
		exc.printStackTrace();
	}finally{
		if(rs!=null)try{rs.close();}catch(SQLException ignore){}
		if(ps!=null)try{ps.close();}catch(SQLException ignore){}
		if(dbConn!=null)try{dbConn.close();}catch(SQLException ignore){}
	}
}
}