JDBC连接mysql

来源：互联网发布：java中逻辑或编辑：程序博客网时间：2024/05/20 08:41

设计模式：MVC

根据MVC 模式建立几个包文件

其中：

Dao 与数据库的操作，增删改查等方法

model 一般都是javabean对象，例如与数据库的某个表相关联。

DButil 通常都是工具类，如与数据库连接,字符串处理、日期处理等

view 视图，页面相关的；

control:是一些控制后台和页面访问的类;

1.先编写mode类，关联数据表：

import java.util.Date;public class Goddess {private Integer id;private String user_name;private Integer sex;private Integer age;private Date birthday;private String email;private String mobile;private String create_user;private String update_user;private Date create_date;private Date update_date;private Integer isdel;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUser_name() {return user_name;}public void setUser_name(String user_name) {this.user_name = user_name;}public Integer getSex() {return sex;}public void setSex(Integer sex) {this.sex = sex;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public String getMobile() {return mobile;}public void setMobile(String mobile) {this.mobile = mobile;}public String getCreate_user() {return create_user;}public void setCreate_user(String create_user) {this.create_user = create_user;}public String getUpdate_user() {return update_user;}public void setUpdate_user(String update_user) {this.update_user = update_user;}public Date getCreate_date() {return create_date;}public void setCreate_date(Date create_date) {this.create_date = create_date;}public Date getUpdate_date() {return update_date;}public void setUpdate_date(Date update_date) {this.update_date = update_date;}public Integer getIsdel() {return isdel;}public void setIsdel(Integer isdel) {this.isdel = isdel;}@Overridepublic String toString() {return "Goddess [id=" + id + ", user_name=" + user_name + ", sex="+ sex + ", age=" + age + ", birthday=" + birthday + ", email="+ email + ", mobile=" + mobile + ", create_user=" + create_user+ ", update_user=" + update_user + ", create_date="+ create_date + ", update_date=" + update_date + ", isdel="+ isdel + "]";}}

2.然后是DButil层，这里主要是连接数据库的操作；

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DBUtil {private static final String URL = "jdbc:mysql://127.0.0.1:3306/test_learn";private static final String USER = "root";private static final String PASSWORD = "1234567";private static Connection connection = null;//该类一加载就获得数据库连接static {// 1.通过反射加载驱动程序，通过类名反向的将这个类加载到环境中try {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}// 2.获得数据库的连接,注意Connection是java.sql包下的Connectiontry {connection = DriverManager.getConnection(URL, USER, PASSWORD);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}//对外提供这个连接,必须是静态方法，才能直接用类调用。public static Connection getConnection() {return connection;}}

阅读全文

0 0