javaee-jdbc
来源:互联网 发布:金博医疗器械软件 编辑:程序博客网 时间:2024/05/16 07:11
1、先要导入jdbc-mysql包
2、程序框架:
3、数据库配置文件
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/jdbc_db
username=root
password=1234
4、访问底层数据:
package cn.com.dale.utils;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class Utils {
public Connection openConnection(){
Properties pro = new Properties();
try {
pro.load(this.getClass().getClassLoader().getResourceAsStream("DBConfig.properties"));
String driver = pro.getProperty("driver");
String url = pro.getProperty("url");
String username = pro.getProperty("username");
String password = pro.getProperty("password");
Class.forName(driver);
return DriverManager.getConnection(url,username,password);
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public void closeConnection(Connection conn){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
5、javabean:
package cn.com.dale.Bean;
public class User {
private String name;
private String password;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
6、接口:
package cn.com.dale.Dao;
import cn.com.dale.Bean.User;
public interface UserDao {
//denglu
public User login(User user);
//zhuce
public void register(User user);
//jiancha
public boolean check(String name);
}
7、接口实现类:
package cn.com.dale.DaoImpl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import cn.com.dale.Bean.User;
import cn.com.dale.Dao.UserDao;
import cn.com.dale.utils.Utils;
public class UserDaoImpl implements UserDao{
public void register(User user) {
if(check(user.getName())==false){
System.out.println("该用户名已存在!");
return;
}
String sql = "insert into usertab(username,password) values(?,?)";
Utils utils = new Utils();
Connection conn = utils.openConnection();
try {
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1,user.getName());
stmt.setString(2, user.getPassword());
stmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
utils.closeConnection(conn);
}
}
public User login(User user) {
String sql="select * from usertab where username=? and password=?";
Utils utils = new Utils();
Connection conn = utils.openConnection();
try {
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, user.getName());
stmt.setString(2, user.getPassword());
ResultSet rs = stmt.executeQuery();
if(rs.next()){
return user;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
utils.closeConnection(conn);
}
return null;
}
public boolean check(String name) {
String sql = "select * from usertab where username=?";
Utils utils = new Utils();
Connection conn = utils.openConnection();
try {
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, name);
ResultSet rs = stmt.executeQuery();
if(rs.next()){
return false;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
utils.closeConnection(conn);
}
return true;
}
}
8、测试:
package cn.com.dale.test;
import org.junit.Test;
import cn.com.dale.Bean.User;
import cn.com.dale.Dao.UserDao;
import cn.com.dale.DaoImpl.UserDaoImpl;
public class test01 {
@Test
public void test(){
//Utils utils = new Utils();
//System.out.println(utils.openConnection());
User user = new User();
user.setName("小非");
user.setPassword("123");
UserDao userDao = new UserDaoImpl();
userDao.register(user);
User user1 = userDao.login(user);
System.out.println(user1.getName()+":"+user1.getPassword());
}
}
- javaee-jdbc
- 【JavaEE】JDBC
- javaEE JDBC
- javaEE jdbc编程步骤
- javaEE jdbc事务管理
- javaEE jdbc批处理
- 【概念笔记】JavaEE - jdbc
- JAVAEE学习之JDBC
- 【JavaEE】JDBC基本技术
- 【javaEE】【Mybatis】【JDBC】问题
- javaEE 使用JDBC进行批处理
- JavaEE之JDBC编程[详解]
- 基于javaEE的结构体系之jdbc
- javaee学习之路(十八)JDBC
- JavaEE学习12--JDBC(上)
- JavaEE学习12—JDBC(下)
- javaEE 中jdbc加载数据库驱动失败
- JavaEE项目JDBC连接MySql数据库提示ClassNotFoundException的解决方案
- USACO--2.1Ordered Fractions
- Xcode描述文件路径
- 灰度图像--图像分割 区域分割之区域分离
- div模拟text输入框
- selector属性设置详解
- javaee-jdbc
- 内核驱动开发第五天linux系统调用
- /var/log目录下的Linux日志
- [LeetCode] Consecutive Numbers - SQL
- Java 中对类的主动引用和被动引用
- 使用Bash中Complete自动补全命令
- Spring4 学习笔记(3)-Spring 基于 XML 的方式配置 Bean
- CalendarView组件
- HDU ACM 4535 吉哥系列故事——礼尚往来