package cn.com.oneqinglong.JDBCTest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
/**
*
* @author oneqinglong
*
*1.加载驱动
*
*2.和数据库建立连接
*
*3.建立Statement对象
*
*4.创建sql语句和执行sql语句
*
*5.处理结果集
*
*6.关闭资源
*
*
*/
public class JDBCUtil {
/**
* 功能:添加person
* @param personId 编号
* @param personName 姓名
* @param personSex 性别
* @param personAge 年龄
*/
public void addPerson(int personId,String personName,String personSex,int personAge){
String className="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/oneqinglong";
String user="root";
String password="123456";
Connection con=null;
Statement stm=null;
try {
Class.forName(className);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
con=DriverManager.getConnection(url, user, password);
stm=con.createStatement();
String sql="insert into person values("+personId+",'"+personName+"','"+personSex+"',"+personAge+")";
int a=stm.executeUpdate(sql);
if(a==1){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(con!=null){
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stm!=null){
try {
stm.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
/**
* 功能:添加person
* @param personId 编号
* @param personName 姓名
* @param personSex 性别
* @param personAge 年龄
*/
public void addPerson2(int personId,String personName,String personSex,int personAge){
String className="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/oneqinglong";
String user="root";
String password="123456";
Connection con=null;
PreparedStatement stm=null;
try {
Class.forName(className);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
con=DriverManager.getConnection(url, user, password);
String sql="insert into person values(?,?,?,?)";
stm=con.prepareStatement(sql);
stm.setInt(1, personId);
stm.setString(2, personName);
stm.setString(3, personSex);
stm.setInt(4, personAge);
int a=stm.executeUpdate();
if(a==1){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(con!=null){
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stm!=null){
try {
stm.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
package cn.com.oneqinglong.JDBCTest;
import java.util.Scanner;
public class JDBCTest {
public static void main(String[] args) {
Scanner scr=new Scanner(System.in);
System.out.println("请输入personId号:");
int personId=scr.nextInt();
System.out.println("请输入personName:");
String personName=scr.next();
System.out.println("请输入personSex:");
String personSex=scr.next();
System.out.println("请输入personAge:");
int personAge=scr.nextInt();
new JDBCUtil().addPerson2(personId, personName, personSex, personAge);
}
}