import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBTest {
public static void main(String[] args) {
Connection conn;
Statement st;
ResultSet rs;
String userName="sa";
String userPassword="a123456";
String url="jdbc:sqlserver://localhost:1433; DatabaseName=lihongchao";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection(url,userName,userPassword);
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from Table2";
rs=st.executeQuery(sql);
while(rs.next()){
String classid=rs.getString(1);
String classname=rs.getString(2);
String classgrade=rs.getString(3);
System.out.println("classid:"+classid);
System.out.println("classname:"+classname);
System.out.println("classgrade:"+classgrade);
}
} catch (ClassNotFoundException e) {
System.out.println("创建失败");
} catch (SQLException e) {
System.out.println("出错:"+e.getMessage());
}
}
}