使用JDBC访问SQL Server数据库

        关于环境的配置可以看之前的文章，这是一个访问数据库的Demo，可以根据自己的要求做简单的修改

 

import java.sql.*;

public class SQLDemo {
	private static final String JDBC_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//设置SQL Server数据库引擎
	private static final String DATABASE = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=MyDatabase";//指定数据库
	private static final String DB_USER = "sa";//数据库登录名
	private static final String DB_PASSWORD = "";//数据库登陆密码
	
	public static void main(String[] args) {
		Connection connection = null;
		
		try {
			Class.forName(JDBC_DRIVER);
			connection = DriverManager.getConnection(DATABASE, DB_USER, DB_PASSWORD);//登录数据库
			
			//create(connection);
			//insert(connection);
			//query(connection);
			//updateInfo(connection);
			//updatePassword(connection);
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			System.out.println("数据库加载失败");
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("数据库访问失败");
			e.printStackTrace();
		} finally {
			if(connection != null){
				try {
					connection.close();
				} catch (SQLException e) {
					//ignore
				}
			}
		}
	}
	
	public static void create(Connection connection) throws SQLException{
		String cmd = "create table DRIVER( "
				+ "PHONE varchar(11) primary key, "
				+ "PASSWORD varchar(16) not null, "
				+ "ID_NUMBER varchar(19), "
				+ "USER_NAME nvarchar(10), "
				+ "DRIVING_LICENCE varchar(19), "
				+ "NICK_NAME nvarchar(10) "
				+ ")";
		
		connection.createStatement().execute(cmd);
	}
	
	public static void insert(Connection connection) throws SQLException{
		String cmd = "insert into DRIVER(PHONE, PASSWORD, ID_NUMBER, USER_NAME, DRIVING_LICENCE, NICK_NAME) "
				+ "values( ?, ?, ?, ?, ?, ?)";
		
		PreparedStatement statement = connection.prepareStatement(cmd);
		statement.setString(1, "12345678910");
		statement.setString(2, "123456");
		statement.setString(3, "123456");
		statement.setString(4, "babao");
		statement.setString(5, "123456");
		statement.setString(6, "imbabao");
		statement.executeUpdate();
	}
	
	public static void query(Connection connection) throws SQLException{
		String cmd = "select * "
				+ "from DRIVER";
		
		PreparedStatement statement = connection.prepareStatement(cmd);
		ResultSet resultSet = statement.executeQuery();
		while(resultSet.next()){
			for(int i = 1; i <= 6; ++i){
				System.out.println(resultSet.getString(i) + "|");
			}
		}
	}
	
	public static void updateInfo(Connection connection) throws SQLException{
		String cmd = "update Driver set "
				+ "ID_NUMBER = ?, "
				+ "USER_NAME = ?, "
				+ "DRIVING_LICENCE = ?, "
				+ "NICK_NAME = ? "
				+ "where phone = ?";
		
		PreparedStatement statement = connection.prepareStatement(cmd);
		statement.setString(1, "330304");
		statement.setString(2, "babao");
		statement.setString(3, "330304");
		statement.setString(4, "imbabao");
		statement.executeUpdate();		
	}
	
	public static void updatePassword(Connection connection) throws SQLException{
		String cmd = "update Driver set PASSWORD = ? where phone = ?";
		
		PreparedStatement statement = connection.prepareStatement(cmd);
		statement.setString(1, "password");
		statement.setString(2, "12345678910");
		statement.executeUpdate();
	}
}