简单的增删改查
public class JdbcTest {
static String url = "jdbc:mysql://localhost:3306/test";
static String username= "root";
static String password = "123456";
static Connection conn = null;
static Statement sta = null;
static ResultSet rs = null;
public static void main(String[] args) {
select();
}
private static void add() {
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url,username,password);
sta = conn.createStatement();
String sql = "insert into student (id,`name`) values (1,'大熊')";
int result = sta.executeUpdate(sql);
if(result>0){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
sta.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}
}
private static void update() {
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url,username,password);
sta = conn.createStatement();
String sql = "update student set `name` = '大黑' where id = 1";
int result = sta.executeUpdate(sql);
if(result>0){
System.out.println("修改成功");
}else{
System.out.println("修改失败");
}
sta.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}
}
private static void delete() {
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url,username,password);
sta = conn.createStatement();
String sql = "delete from student where id = 1";
int result = sta.executeUpdate(sql);
if(result>0){
System.out.println("删除成功");
}else{
System.out.println("删除失败");
}
sta.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}
}
private static void select() {
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url,username,password);
sta = conn.createStatement();
String sql = "select * from student";
rs = sta.executeQuery(sql);
while (rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
System.out.println("id"+id+" name"+name);
}
rs.close();
sta.close();
conn.close();
}catch (Exception e){
e.printStackTrace();
}
}
}
通用方法
public class JdbcUtils {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
String username = "root";
String password = "123";
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
public Connection getConn(){
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,username,password);
return conn;
}catch (Exception e){
e.printStackTrace();
}
return conn;
}
public int excuteUp(String sql,Object []params){
try {
ps = getConn().prepareStatement(sql);
if (params!=null){
for (int i=0; i<params.length;i++){
ps.setObject(i+1,params[i]);
}
}
int result = ps.executeUpdate();
return result;
}catch (Exception e){
e.printStackTrace();
}
return 0;
}
public ResultSet excuteSet(String sql,Object[] params){
try {
conn =this.getConn();
ps = getConn().prepareStatement(sql);
if (params!=null){
for (int i =0; i<params.length; i++){
ps.setObject(i+1,params[i]);
}
}
rs =ps.executeQuery();
}catch (Exception e){
e.printStackTrace();
}
return rs;
}
public void closeALL(Connection conn,PreparedStatement ps,ResultSet rs){
try {
if (rs!=null){
rs.close();
}
if (ps!=null){
ps.close();
}
if (conn!=null){
conn.close();
}
}catch (Exception e){
e.printStackTrace();
}
}
}