java连接oraclejdbc_Java连接Oracle的JDBC插入数据操作

增加数据的操作

接口

package dao;

import java.util.List;

import bean.User;

public interface UserDao {

//插入

public int insertUser(User user);

//查询

public List queryUsers(User user);

}

实现类

package dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import bean.User;

import util.DBUtil;

public class UserDaoImpl implements UserDao {

@Override

public int insertUser(User user) {

Connection conn=DBUtil.getConnection();

PreparedStatement ps=null;

ResultSet rs=null;

String sql="INSERT INTO T_USER(USER_ID,USER_ACCOUNT,REAL_NAME,SEX,BIRTHDAY) VALUES(SEQ_T_USER.NEXTVAL,?,?,?,TO_DATE(?,'yyyy-mm-dd'))";

try {

ps=conn.prepareStatement(sql);

ps.setString(1, user.getUserAccount());

ps.setString(2, user.getUsername());

ps.setInt(3, user.getSex());

ps.setString(4,user.getBirthday());

return ps.executeUpdate();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return 0;

}

@Override

public List queryUsers(User user) {

List users=new ArrayList();

Connection conn=DBUtil.getConnection();

PreparedStatement ps=null;

ResultSet rs=null;

String sql="SELECT USER_ID,USER_ACCOUNT,REAL_NAME,BIRTHDAY FROM T_USER WHERE 1=1";

try {

//这是动态拼接查询条件

if(user.getUsername()!=null && user.getUsername().equals("")) {

sql+= "AND REAL_NAME LIKE ?";

}

ps=conn.prepareStatement(sql);

//有多个条件+多个条件的判断

if(user.getUsername()!=null && user.getUsername().equals("")) {

ps.setString(1, "%"+user.getUsername()+"%");

}

rs=ps.executeQuery();

while(rs.next()) {

String userName=rs.getString("REAL_NAME");

int userId=rs.getInt("USER_ID");

User temp=new User();

temp.setUserId(userId);

temp.setUsername(userName);

users.add(temp);

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally {

DBUtil.closeConn(conn, ps, rs);

}

return users;

}

}

走到天涯海角

发布了38 篇原创文章 · 获赞 37 · 访问量 1745

私信

关注

标签：ps,JDBC,Java,User,user,sql,Oracle,import,USER

来源： https://blog.csdn.net/weixin_42995083/article/details/104161352