1.思想就是在数据库的增 删 改 查 中每步中都需要连接到数据库,为了简化代码。使用javaBean 分别把用户类,连接类,操作类 打包
2
login代码:
- <form action=“dologin.jsp” method=“post”>
- 用户名:<input type=“text” name=“username” value=“”><br>
- 密 码:<input type=“password” name=“password” value=“”><br>
- 用户类型:
- <select name=“type”>
- <option value=“管理员”>管理员</option>
- <option value=“普通用户”>普通用户</option>
- </select><br>
- <input type=“submit” value=“注册”>
- <input type=“reset” value=“取消”>
- </form>
<form action="dologin.jsp" method="post">
用户名:<input type="text" name="username" value=""><br>
密 码:<input type="password" name="password" value=""><br>
用户类型:
<select name="type">
<option value="管理员">管理员</option>
<option value="普通用户">普通用户</option>
</select><br>
<input type="submit" value="注册">
<input type="reset" value="取消">
</form>
dolign代码:
- <%@page import=“java.sql.*” %> <!– 调用java 包 –>
- <%@ page import=“nuc.test.user.User” %> <!–调用User类 –>
- <%@ page import=“nuc.test.Dao.UserDao” %> <!–调用Dao类 –>
- <%request.setCharacterEncoding(“utf-8”); %> <!– 修改字符集 –>
- <jsp:useBean id=“userxt” class=“nuc.test.user.User” > <!–class=包名.类名 –>
- <jsp:setProperty name=“userxt” property=“*”/> <!– 设置javaBean属性 *代表自动匹配数据库–>
- </jsp:useBean>
- <%
- UserDao user=new UserDao();//实例化
- user.Insert(userxt); //调用Insert方法,实现增加数据
- %>
<%@page import="java.sql.*" %> <!-- 调用java 包 -->
<%@ page import="nuc.test.user.User" %> <!--调用User类 -->
<%@ page import="nuc.test.Dao.UserDao" %> <!--调用Dao类 -->
<%request.setCharacterEncoding("utf-8"); %> <!-- 修改字符集 -->
<jsp:useBean id="userxt" class="nuc.test.user.User" > <!--class=包名.类名 -->
<jsp:setProperty name="userxt" property="*"/> <!-- 设置javaBean属性 *代表自动匹配数据库-->
</jsp:useBean>
<%
UserDao user=new UserDao();//实例化
user.Insert(userxt); //调用Insert方法,实现增加数据
%>
User.java用户类
- package nuc.test.user;
- public class User {
- private String username; //定义用户名
- private String password; //定义密码
- private String type; //定义类型
- private String id; //定义id名
- //set和get方法
- public String getUsername(){
- return username;
- }
- public void setUsername(String username){
- this.username=username;
- }
- public String getPassword(){
- return password;
- }
- public void setpassword(String password){
- this.password=password;
- }
- public String getType(){
- return type;
- }
- public void setType(String type){
- this.type=type;
- }
- public String getId(){
- return id;
- }
- public void setId(String id){
- this.id=id;
- }
- }
package nuc.test.user;
public class User {
private String username; //定义用户名
private String password; //定义密码
private String type; //定义类型
private String id; //定义id名
//set和get方法
public String getUsername(){
return username;
}
public void setUsername(String username){
this.username=username;
}
public String getPassword(){
return password;
}
public void setpassword(String password){
this.password=password;
}
public String getType(){
return type;
}
public void setType(String type){
this.type=type;
}
public String getId(){
return id;
}
public void setId(String id){
this.id=id;
}
}
UserCoon.java连接类
- package nuc.test.coon;
- import java.sql.*;//调用java包
- public class UserCoon {
- public static final String DBDRIVER=“org.gjt.mm.mysql.Driver”; //常量驱动
- public static final String DBURL=“jdbc:mysql://localhost:3306/user”;//常量地址
- public static final String DBUSER=“root”;//用户名
- public static final String DBPASS=“15735659458zxc”;//密码
- Connection conn=null;
- //getCoon方法 返回值为 Connection conn
- public Connection getCoon(){
- try {//抛出异常
- Class.forName(DBDRIVER);//驱动数据库
- conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);//连接数据库
- } catch (Exception e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return conn;
- }
- }
package nuc.test.coon;
import java.sql.*;//调用java包
public class UserCoon {
public static final String DBDRIVER="org.gjt.mm.mysql.Driver"; //常量驱动
public static final String DBURL="jdbc:mysql://localhost:3306/user";//常量地址
public static final String DBUSER="root";//用户名
public static final String DBPASS="15735659458zxc";//密码
Connection conn=null;
//getCoon方法 返回值为 Connection conn
public Connection getCoon(){
try {//抛出异常
Class.forName(DBDRIVER);//驱动数据库
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);//连接数据库
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
}
UserDao.java操作类
- package nuc.test.Dao;
- import java.sql.*;//调用java包
- import nuc.test.coon.*;//调用Conn包
- import nuc.test.user.*;//调用User包
- public class UserDao{
- //Insert方法 参数是user 返回值为int rs
- public int Insert(User usera){
- PreparedStatement pst=null;
- int rs=0;
- UserCoon coon=new UserCoon(); //实例化UserCoon
- Connection coona=coon.getCoon(); //获取getCoon
- String sql_insert=“insert into user_table(username,password,type) values(?,?,?)”; //sql语句
- try {//抛出异常
- pst=coona.prepareStatement(sql_insert);//执行sql语句
- pst.setString(1,usera.getUsername());//获取值
- pst.setString(2,usera.getPassword());
- pst.setString(3,usera.getType());
- rs=pst.executeUpdate();
- } catch (Exception e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return rs;
- }
- }
package nuc.test.Dao;
import java.sql.*;//调用java包
import nuc.test.coon.*;//调用Conn包
import nuc.test.user.*;//调用User包
public class UserDao{
//Insert方法 参数是user 返回值为int rs
public int Insert(User usera){
PreparedStatement pst=null;
int rs=0;
UserCoon coon=new UserCoon(); //实例化UserCoon
Connection coona=coon.getCoon(); //获取getCoon
String sql_insert="insert into user_table(username,password,type) values(?,?,?)"; //sql语句
try {//抛出异常
pst=coona.prepareStatement(sql_insert);//执行sql语句
pst.setString(1,usera.getUsername());//获取值
pst.setString(2,usera.getPassword());
pst.setString(3,usera.getType());
rs=pst.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
}