58,454
社区成员
发帖
与我相关
我的任务
分享
// filename:App16_15.java
import java.sql.*;
public class App16_15
{
private static String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String url="jdbc:sqlserver://localhost:1433;DatabaseName=Study";
private static String user="sa";
private static String password="12345";
public static void main(String[] args)
{
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try
{
Class.forName(driver);
conn=DriverManager.getConnection(url, user, password);
String sql="select s_no,s_name form Student";
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{
String no=rs.getString("s_no");
String name=rs.getString("s_name");
System.out.println(no+" "+name);
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally {
try {
if(rs !=null) rs.close();
if(stmt !=null) stmt.close();
if(conn !=null) conn.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
}