在处理结果集的过程中,取值都是跟查询的结果有关
DAO模式:Database Access Object(数据库访问对象)
JDBC--》类
BaseDAO
package com.neusoft.test1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class BaseDAO {
private static Connection conn;
public static final String Driver="com.mysql.jdbc.Driver";
public static final String URL="jdbc:mysql://localhost:3306/test";
public static final String USERNAME="root";
public static final String PASSWORD="cao416151";
public Connection getconn(){
return conn;
}
static{
//1.
//2.
try {
Class.forName(Driver);
conn=DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void Close(Statement statement,Connection connection){
try {
if(statement!=null)
{
statement.close();}
if(connection!=null)
{
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void Close(ResultSet resultSet,Statement statement,Connection connection){
try {
if(resultSet!=null)
{
resultSet.close();}
if(statement!=null)
{
statement.close();}
if(connection!=null)
{
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
BusinessDao
package com.neusoft.test1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
public class BusinessDao extends BaseDAO{
public void addBusiness(){
String sql="instert into business(xxx,xxx,xxx) values(?,?,?)";
PreparedStatement pstmt=null;
try {
pstmt=getconn().prepareStatement(sql);
pstmt.setString(1, "");
pstmt.setString(1, "");
pstmt.setString(1, "");
pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
Close(pstmt, null);
}
}
public void deleteBusiness(){
}
public void updateBusiness(){
}
}
UserDao
package com.neusoft.test1;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class UserDao extends BaseDAO{
ResultSet resultSet=null;
PreparedStatement preparedStatement=null;
public void login(String username,String password)
{
String sql="select * from userinfo where username= ? and password= ?";
try {
preparedStatement = getconn().prepareStatement(sql);
preparedStatement.setString(1,username);
preparedStatement.setString(2,password);
resultSet=preparedStatement.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Close(resultSet, preparedStatement, null);
}
}
}
ORM思想:object relationship
数据库中表是真实存在的,Java以面向对象的角度去看,Java就会把整个数据库的关系体现用Java的面向对象体现出来,把每一张表映射成类
表中的每条记录就是一个对象,这就形成了一种映射关系。表中的字段对应成了类中的每一个属性也形成了映射
对象关系映射
这种类被称为实体类,它就表示相应的实体