package demo2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class text {
private static Connection dbConn = null;
public static void main(String[] args) {
// TODO Auto-generated method stub
String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=eladb";
String name="sa";
String password="123";
String select="select * from [elatab]";
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
dbConn=DriverManager.getConnection(dbURL,name,password);
System.out.println("链接数据库成功");
PreparedStatement statement=null;
statement=dbConn.prepareStatement(select);
ResultSet res=null;
res=statement.executeQuery();
while(res.next())
{
String Sno=res.getString("id");
String Sname=res.getString("name");
System.out.println("学号："+Sno+"姓名"+Sname);
}
}catch(Exception e)
{
}
}
}
