import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class Mains {
private static String driver;
private static String url;
private static String username;
private static String password;
private static Connection conn;
public static void main(String[] args) {
// 读取properties配置文件
// Properties prop=new Properties();
// try {
// prop.load(new FileInputStream("ss.properties"));//配置文件名
// driver=prop.getProperty("jdbc.driver");
// url=prop.getProperty("jdbc.url");
// username=prop.getProperty("jdbc.username");
// password=prop.getProperty("jdbc.password");
// }catch (IOException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
driver = "com.microsoft.sqlserver.jdbc.sqlserverdriver";
url = "jdbc:sqlserver://localhost:1433;database=school";
username = "sa";
password = "sa123";
try {
//装载驱动SQLServerDriver.class
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection(url, username, password);
/*
* 也可以这样连在一起写
* conn=DriverManager.getConnection(
* "jdbc:sqlserver://localhost:1433;User=sa;Password=sa123;DatabaseName=school"
* );
*/
/* Statement 执行基本的sql语句
* PreparedStatement 执行带参数的sql语句
* CallableStatement 执行存储过程
*/
Statement stmt = conn.createStatement();
String sql = "select * from student";
/* executeUpdate()执行更新语句,如insert,update,delete
* executeQuery()执行查询语句,返回结果集
* execute()
*/
//返回ResultSet结果集
ResultSet rs = stmt.executeQuery(sql);
//逐行读取
while (rs.next()) {
System.out.println("stu_name:" + rs.getString("stu_name"));
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
jdbc连接sql数据库详解
最新推荐文章于 2023-03-09 11:31:56 发布