Java使用SQLServer开发的步骤

Java使用SQLServer开发的步骤

OOOO一定要注意包，不要起无意义的名称OOOO

1.准备SQL语句，建库，建表

create database game
on
(
	name='game',
	filename='D:\sql\game.mdf'
)

use game
go

create table users(
	id int primary key identity(1,1),
	username varchar(10),
	userpwd varchar(10),
	qm varchar(50)
)

select * from users

2.写DBHelper.java 这个是们获取数据库驱动连接的 对象，以及关闭使用后的对象

2.1 加载的配置文件 db.properties 这个文件必须和 DBHelper.java类放在同一个包中

driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://127.0.0.1:1433;databaseName=game
name=sa
pwd=1

2.2 DBHelper.java

​ 灵活运用Alt+/ 以及 crtl+1

package com.wpf.util;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class DBHelper {
	//4个变量参数
	private static String name;
	private static String pwd;
	private static String driver;//驱动 com.microsoft.sqlserver.jdbc.SQLServerDriver
	private static String url;// jdbc:sqlserver://127.0.0.1:1433;databaseName=[数据库名称]
	
	//接下来该什么了？  读取配置文件 设置初始化数据
	static{
		Properties properties = new Properties();
		try {
			properties.load(DBHelper.class.getResourceAsStream("db.properties"));
			name = properties.getProperty("name");
			pwd = properties.getProperty("pwd");
			url = properties.getProperty("url");
			driver = properties.getProperty("driver");
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	//创建连接
	public static Connection getConn(){
		Connection conn = null;
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, name, pwd);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();//打印出捕获的错误信息
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	
	//关闭连接
	public static void close(Connection con,PreparedStatement ps,ResultSet rs){
		try {
			if(rs!=null){
				rs.close();
			}
			if(ps!=null) ps.close();
			if(con!=null) con.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}

3.创建 存储数据用的model对象

Users.java

package com.wpf.model;

public class Users {

	private int id;
	private String username;
	private String userpwd;
	private String qm;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getUserpwd() {
		return userpwd;
	}
	public void setUserpwd(String userpwd) {
		this.userpwd = userpwd;
	}
	public String getQm() {
		return qm;
	}
	public void setQm(String qm) {
		this.qm = qm;
	}
	@Override
	public String toString() {
		return "Users [id=" + id + ", qm=" + qm + ", username=" + username
				+ ", userpwd=" + userpwd + "]";
	}
}

4.创建数据库调用的DAO层内容

UsersDao.java

package com.wpf.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.wpf.model.Users;
import com.wpf.util.DBHelper;

public class UsersDao {
	
	//插入数据到 表中
	public int insertUsers(Users user){
		int count = 0;
		
		//1.获取连接  
		Connection con = DBHelper.getConn();
		PreparedStatement ps = null;
		//2.准备sql语句
		String insertSql = "insert into users values (?,?,?)";
		try {
			//3.预编译语句
			ps = con.prepareStatement(insertSql);
			//4.设置参数
			ps.setString(1, user.getUsername());
			ps.setString(2, user.getUserpwd());
			ps.setString(3, user.getQm());
			//5.执行sql语句
			count = ps.executeUpdate();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
            //6.关闭数据库
			DBHelper.close(con, ps, null);
		}
		
		return count;
	}
	
	//测试上面写的代码是否可以运行
	public static void main(String[] args) {
		//准备一个Users对象 作为数据的容器
		Users user = new Users();
		user.setUsername("晓晓");
		user.setUserpwd("321");
		user.setQm("签名");
		UsersDao usersDao = new UsersDao();
		int count = usersDao.insertUsers(user);
		System.out.println(count);
	}

}

s user = new Users();
user.setUsername(“晓晓”);
user.setUserpwd(“321”);
user.setQm(“签名”);
UsersDao usersDao = new UsersDao();
int count = usersDao.insertUsers(user);
System.out.println(count);
}

}