- 543 名前：デフォルトの名無しさん [2007/06/26(火) 18:24:56 ]
- メソッド化お願いします。
import java.sql.*;
public class DbAccess{
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
onnection 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);
}
}
}
|
 |
