JDBC示例程序

package javajdbc;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


import sun.font.CreatedFontTracker;


public class JavaJDBC {


public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
PreparedStatement cs = null;
ResultSet rs = null;
//1.加载驱动
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

//2.获取连接
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName =student", "sa", "123456");
//3.准备执行
String qname = "计算机";
String sql = "select 学号,姓名,总学分 from xs where 专业名 = ? " ;

cs = conn.prepareStatement(sql);
cs.setString(1, qname);
//4.获取结果
rs = cs.executeQuery();
                        System.out.println("学号\t"+ "姓名\t"+ "总学分\t");
while (rs.next()) {
String id = rs.getString(1);
String name = rs.getString(2);
int score = rs.getInt(3);
System.out.println(id + "\t"+name + "\t"+score + "\t");
}
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
} catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
} finally {
//5.释放资源
try {
if (rs!=null) {
rs.close();
}
if (cs!=null) {
cs.close();
}
if (conn!=null) {
conn.close();
}
} catch (SQLException e2) {
// TODO: handle exception
e2.printStackTrace();
}

}



}


}