MVC设计模式
MVC开始是存在于桌面程序中的,M是指业务模型,V是指用户界面,C则是控制器,使用MVC的目的是将M和V的实现代码分离,从而使同一个程序可以使用不同的表现形式。
这是M,即数据类,是一个业务模型,在这里是建立数据库,并与数据库建立连接
package com.lingzhuo.sqlmvc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class SqlManger {
private Connection connection;
private Statement state;
public Connection getConnection() {
return connection;
}
public void setConnection(Connection connection) {
this.connection = connection;
}
public Statement getState() {
return state;
}
public void setState(Statement state) {
this.state = state;
}
private static SqlManger manger;
public static synchronized SqlManger newInstance(){
if(manger==null){
manger=new SqlManger();
}
return manger;
}
private SqlManger(){
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/clazz";
String user = "root";
String password = "1639189";
try {
Class.forName(driver);
connection=DriverManager.getConnection(url,user,password);
state=connection.createStatement();//数据库操作类
String userTable = "create table if not exists user(id int(10)not null primary key auto_increment,name varchar(20)binary not null,password varchar(20)binary not null)";
state.execute(userTable);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}