连接sql+添加用户
DBConnection
import java.sql.Connection;
import java.sql.DriverManager;import java.sql.SQLException;
public class DBConnection {
static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
static String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=userDB";
public static Connection getCon(){
Connection con=null;
try {
//加载驱动
Class.forName(driver);
//创建连接
con = DriverManager.getConnection(dbURL,"sa","sa");
} catch (ClassNotFoundException e) {
System.out.println("无法加载驱动");
e.printStackTrace();
} catch(SQLException e){
System.out.println("无法连接数据库");
e.printStackTrace();
}
return con;
}
public static void main(String[] args){
if(DBConnection.getCon()!=null){
System.out.println("连接成功");
}else{
System.out.println("连接失败");
}
}
}
Run
import java.util.Scanner;
public class Run {
public static void main(String[] args) {
//为cuse创建对象
Scanner input = new Scanner(System.in);
System.out.println("请输入你的姓名:");
String name=input.next();
System.out.println("请输入你的密码:");
String password = input.next();
User user =new User(name,password);
UserDAO add = new UserDAO();
//注册新用户
if(add.Adduser(user)!=0){
System.out.println("插入成功!");
}else{
System.out.println("插入失败?");
}
}
}
User
public class User {
protected int ID;
protected String Name;
protected String PassWord;
public String getName() {
return Name;
}
public void setName(String name) {
Name = name;
}
public String getPassWord() {
return PassWord;
}
public void setPassWord(String passWord) {
PassWord = passWord;
}
public int getID() {
return ID;
}
//构造方法
public User(String name, String passWord) {
super();
Name = name;
PassWord = passWord;
}
}
UserDAO
mport java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class UserDAO {
//添加用户
String sql;
//预处理对象
PreparedStatement ps = null;
//添加用户
public int Adduser(User user){
Connection con = null;
sql = "insert into users values(?,?)";//占位符
con = DBConnection.getCon();
int i = 0;
try{
ps = con.prepareStatement(sql);
//处理占位符
ps.setString(1, user.getName());
ps.setString(2, user.getPassWord());
i = ps.executeUpdate();//执行sql语句
}catch(SQLException e){
e.printStackTrace();
}finally{
//关闭对象
try {
ps.close();
con.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
}
return i;
}
}