import java.sql.*;
public class Test {
public static void main(String[] args) {
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=JSPTest","sa","123");
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// con = DriverManager.getConnection("jdbc:odbc:JDBCSQLDemo_JSPTest");
stmt = con.createStatement();
rs = stmt.executeQuery("select userName,passWord,email from regist");
while(rs.next()){
String strUserName = rs.getString(1);
String strPassWord = rs.getString(2);
String strEmail = rs.getString("email");
System.out.println(strUserName+"\t"+strPassWord+"\t"+strEmail+"\t");
}
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(con!=null)
con.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
System.out.println("Game Over~");
}
}
}
import java.sql.*;
public class Test {
public static void main(String[] args) {
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=JSPTest","sa","123");
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// con = DriverManager.getConnection("jdbc:odbc:JDBCSQLDemo_JSPTest");
stmt = con.createStatement();
rs = stmt.executeQuery("select userName,passWord,email from regist");
while(rs.next()){
String strUserName = rs.getString(1);
String strPassWord = rs.getString(2);
String strEmail = rs.getString("email");
System.out.println(strUserName+"\t"+strPassWord+"\t"+strEmail+"\t");
}
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(con!=null)
con.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
System.out.println("Game Over~");
}
}
}