07/06/26 18:43:58
>>543 onnection→Connection
import java.sql.*;
public class DbAccess{
public static void main(String[] args){
main();
}
public static void main(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=axiz","sa","sa");
Statement stmt = con.createStatement();
String sql1 ="select * from usertable";
ResultSet rs =stmt.executeQuery(sql1);
while(rs.next()){
String name = rs.getString("userid");
String no = rs.getString("username");
String en = rs.getString("tel");
System.out.println(name);
System.out.println(no);
System.out.println(en);
}
stmt.close();
con.close();
}catch (Exception ex){
System.out.println(ex);
}
}
}