步骤一、建立一个工程WYTest_4并且加入SQL2000的三个jar包,在数据库test中建立表格stu_users;
步骤二、建立一个java类query.java,实现JDBC连接以及查询功能
代码如下:
package com.query;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class query {
Connection conn=null;
PreparedStatement st=null;
ResultSet rs=null;
String
sql="jdbc:microsoft:sqlserver://localhost:1433;databasename=test";
public query(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection(sql,"sa","123456");
}catch(Exception e){
e.printStackTrace();
}
}
public List queryUser(String id,String
dept)throws SQLException{
List list=new
ArrayList();
if(id==null||id.equals("")){
st=conn.prepareStatement("select
* from stu_users where dept=?");
st.setString(1,dept);
rs=st.executeQuery();
while(rs.next()){
JavaBean
jb=new JavaBean();
jb.setId(rs.getString("id"));
jb.setName(rs.getString("name"));
jb.setSex(rs.getString("sex"));
jb.setDept(rs.getString("dept"));
list.add(jb);
}
}else
if(