| 失效链接处理 |
|
JDBC增删改查 PDF 下载
本站整理下载：
相关截图：
主要内容：
com.dao //dao 层作用: 数据访问层, 用来操作数据库表的数据
basedao.java(连接池)
package com.dao;
import java.sql.*;
import java.util.*;
public class basedao {
// 连接池
String Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1434;DatabaseName=mind";
String user = "sa";
String pass = "ok";
Connection conn = null;
public Connection getConnection() {
try {
Class.forName(Driver);
conn = DriverManager.getConnection(url, user, pass);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public void closeconnection() {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} } }minddao controller 层作用: 控制层, 获取界面上的数据,为界面设置数据; 将要实现的功能交
给业务层处理
package com.dao;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.*;
import com.entity.*;
import java.sql.*;
public class minddao extends basedao {
// 查询
public ArrayList<mind> getall() {
ArrayList<mind> list = new ArrayList<mind>();
Connection conn = getConnection();
String sql = "select * from mind";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
mind m = new mind();
m.setId(rs.getInt(1));
m.setTitle(rs.getString(2));
m.setContent(rs.getString(3));
m.setSort(rs.getString(4));
m.setPrice(rs.getString(5));
m.setDate(rs.getString(6));
list.add(m);
}
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
// 添加
public void add(mind m) {
Connection conn = getConnection();
String sql = "insert into mind values(?,?,?,?,?)";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, m.getTitle());
ps.setString(2, m.getContent());
ps.setString(3, m.getSort());
ps.setString(4, m.getPrice());
ps.setString(5, m.getDate());
ps.executeUpdate();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} }
// 修改
public void update(mind m) {
Connection conn = getConnection();
String sql = "update mind set title=?,content=?,Sort=?,Price=?,date=? where id=?";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, m.getTitle());
ps.setString(2, m.getContent());
ps.setString(3, m.getSort());
ps.setString(4, m.getPrice());
ps.setString(5, m.getDate());
ps.setInt(6, m.getId());
ps.executeUpdate();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} }
// 查询一条数据
public ArrayList<mind> show(int id) {
ArrayList<mind> arr = new ArrayList<mind>();
Connection conn = getConnection();
String sql = "select * from mind where id=" + id;
try {
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
mind m = new mind();
m.setId(rs.getInt(1));
m.setTitle(rs.getString(2));
m.setContent(rs.getString(3));
m.setSort(rs.getString(4));
m.setPrice(rs.getString(5));
m.setDate(rs.getString(6));
arr.add(m);
}
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return arr;
}
// 刪除
public void delete(int id) {
Connection conn = getConnection();
String sql = "delete from mind where id=" + id;
try {
Statement stm = conn.createStatement();
stm.executeUpdate(sql);
closeconnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} }
// 详情
public ArrayList<mind> detail(int id) {
ArrayList<mind> arr = new ArrayList<mind>();
Connection conn = getConnection();
String sql = "select * from mind where id=" + id;
try {
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
mind m = new mind();
m.setId(rs.getInt(1));
m.setTitle(rs.getString(2));
m.setContent(rs.getString(3));
m.setSort(rs.getString(4));
m.setPrice(rs.getString(5));
m.setDate(rs.getString(6));
arr.add(m);
}
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return arr;
} }
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
