jdbc连接sql数据库详解

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();
			}
				
			
			
		}
	}

}