Java寒假23

 

 

DbConnection 

package f333;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DbConnection {
public static Connection getConnection() throws SQLException,ClassNotFoundException{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/jsptest";
String name="root";
String password="root";
Connection conn=DriverManager.getConnection(url,name,password);
return conn;
}
public static void release(Statement stmt,Connection conn)
{
if(stmt!=null)
{
try {
stmt.close();
}catch(SQLException e)
{
e.printStackTrace();
}
stmt=null;
}
if(conn!=null)
{
try {
conn.close();
}catch(SQLException e)
{
e.printStackTrace();
}
conn=null;
}

}
public static void release(ResultSet rs,Statement stmt,Connection conn)
{
if(rs!=null)
{
try {
rs.close();
}catch(SQLException e)
{
e.printStackTrace();
}
rs=null;
}
release(stmt,conn);
}
}

 

 

JspUser 

package f333;

public class JspUser {
private String username;
private String password;
private String email;
private int id;
public int getId()
{
return id;
}
public String getUsername()
{
return username;
}
public String getPassword()
{
return password;
}
public String getEmail()
{
return email;
}

public void setId(int id)
{
this.id=id;
}
public void setUsername(String username)
{
this.username=username;
}
public void setPassword(String password)
{
this.password=password;
}
public void setEmail(String email)
{
this.email=email;
}

}

JspUserDao 

package f333;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JspUserDao {

public static int k;
public static boolean check(JspUser user)
{
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try {
conn=DbConnection.getConnection();
stmt=conn.createStatement();
rs=null;
String sql="select * from jspuser where username='"+user.getUsername()+"'";
rs=stmt.executeQuery(sql);
int m=0;
String n=null;
while(rs.next())
{
m=rs.getInt(1);
}
rs.close();
String sql2="select * from jspuser where email='"+user.getEmail()+"'";
rs=stmt.executeQuery(sql2);
while(rs.next())
{
n=rs.getString("email");
}
rs.close();
String sql3="select * from jspuser ";
rs=stmt.executeQuery(sql3);
int co=0;
while(rs.next())
{
co=rs.getInt(1);
}
k=co;
if(m>0||n!=null) return false;
return true;
}catch(Exception e)
{
e.printStackTrace();
}finally {
DbConnection.release(rs, stmt, conn);
}
return false;

}
public static boolean register(JspUser user) throws SQLException, ClassNotFoundException
{
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try {
conn=DbConnection.getConnection();
stmt=conn.createStatement();
rs=null;
String sql="insert into jspuser(id,username,email,password) "+"values("+user.getId()+",'"+
user.getUsername()+"','"+user.getEmail()+"','"+user.getPassword()+"')";
int num=stmt.executeUpdate(sql);
if(num>0) return true;
return false;
}catch(Exception e)
{
e.printStackTrace();
}finally {
DbConnection.release(rs, stmt, conn);
}
return false;

}
}