- 浏览: 272792 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
18335864773:
还是用pageoffice生成excel把。生成excel后不 ...
Servlet 生成excel 并下载JXL方式 -
lliiqiang:
适当处理把条件放到查询中,有特殊情况确实需要特殊处理
lucene 多条件查询 -
chendiego:
不对,1212应该射手,返回水瓶
JAVA计算星座 -
xinming521:
img.attachEvent("onerror&q ...
js验证是否是图片 -
xzorrox3:
谢谢,又小学了一招儿。
页面图片加载失败时自动替换
1、首先创建一个连接类ConnDB.java
package com.cust;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
public class ConnDB {
public Connection conn = null;
public Statement st = null;
public ResultSet rs = null;
public Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://127.0.0.1:3306/cust?user=root&password=123456&useUnicode=true&characterEncoding=UTF-8";
conn = DriverManager.getConnection(url);
return conn;
} catch (Exception e) {
System.out.print("数据库连接失败了");
e.printStackTrace();
}
return null;
}
// 关闭连接
public void closeConnection() {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (st != null) {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
2、创建一个接口类IDao.java
package com.cust;
import java.util.ArrayList;
public interface IDao
{
public int insert(CustBean bea);
public int delete(String id);
public int update(CustBean bea);
public ArrayList selectAll();
public CustBean selectCust(CustBean cBean);
}
3、实现这个接口类CustDAO
package com.cust;
import java.sql.*;
import java.text.DateFormat;
import java.util.*;
import java.util.Date;
public class CustDAO extends ConnDB implements IDao {
PreparedStatement pstmt;
// 实现添加
public int insert(CustBean bea) {
String sql = "insert into cust values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
super.getConnection();
try {
Date now = new Date();
DateFormat d = DateFormat.getDateInstance();
String cDate = d.format(now);
pstmt = conn.prepareStatement(sql);
Calendar CD = Calendar.getInstance();
String id="";
int YY = CD.get(Calendar.YEAR) ;
int MM = CD.get(Calendar.MONTH)+1;
id+=MM;
int DD = CD.get(Calendar.DATE);
id+=DD;
int HH = CD.get(Calendar.HOUR);
id+=HH;
int NN = CD.get(Calendar.MINUTE);
id+=NN;
int SS = CD.get(Calendar.SECOND);
id+=SS;
int MI = CD.get(Calendar.MILLISECOND);
id+=MI;
pstmt.setString(1, id);
pstmt.setString(2, bea.getName());
pstmt.setString(3, bea.getSource());
pstmt.setString(4, bea.getCustServer());
pstmt.setString(5, bea.getCustType());
pstmt.setString(6, bea.getProvince());
pstmt.setString(7, bea.getCity());
pstmt.setString(8, bea.getRegion());
pstmt.setString(9, bea.getAddress());
pstmt.setString(10, bea.getTel());
pstmt.setString(11, bea.getPhone());
pstmt.setString(12, bea.getCarType());
pstmt.setString(13, bea.getAlipay());
pstmt.setString(14, "0");
pstmt.setString(15, cDate);
pstmt.setString(16, cDate);
pstmt.setString(17, bea.getRemark());
int x = pstmt.executeUpdate();
return x;
} catch (SQLException e) {
System.out.println("新成员添加失败!!");
e.printStackTrace();
} finally {
super.closeConnection();
}
return 0;
}
// 实现删除
public int delete(String id) {
String sql = "delete from cust where id=?";
try {
pstmt = super.getConnection().prepareStatement(sql);
pstmt.setString(1, id);
int x = pstmt.executeUpdate();
return x;
} catch (SQLException e) {
System.out.print("删除方法错误!!!");
e.printStackTrace();
} finally {
super.closeConnection();
}
return 0;
}
// 实现查询所有
public ArrayList selectAll() {
String sql = "select * from cust";
ArrayList list = new ArrayList();
try {
pstmt = super.getConnection().prepareStatement(sql);
rs = pstmt.executeQuery();
while (rs.next()) {
CustBean cBean = new CustBean();
cBean.setId(rs.getString(1));
cBean.setName(rs.getString(2));
cBean.setSource(rs.getString(3));
cBean.setCustServer(rs.getString(4));
cBean.setCustType(rs.getString(5));
cBean.setProvince(rs.getString(6));
cBean.setCity(rs.getString(7));
cBean.setRegion(rs.getString(8));
cBean.setAddress(rs.getString(9));
cBean.setTel(rs.getString(10));
cBean.setPhone(rs.getString(11));
cBean.setCarType(rs.getString(12));
cBean.setAlipay(rs.getString(13));
cBean.setTotal(rs.getString(14));
cBean.setCreateDate(rs.getString(15));
cBean.setLastCreateDate(rs.getString(16));
cBean.setRemark(rs.getString(17));
list.add(cBean);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
super.closeConnection();
}
return list;
}
// 实现单个查询
public CustBean selectCust(CustBean cBean) {
CustBean custBean = new CustBean();
try {
if(cBean.getId()==null)
{
String sql = "select * from cust where name=?";
pstmt = super.getConnection().prepareStatement(sql);
pstmt.setString(1, cBean.getName());
}else{
String sql = "select * from cust where id=?";
pstmt = super.getConnection().prepareStatement(sql);
pstmt.setString(1, cBean.getId());
}
rs = pstmt.executeQuery();
while(rs.next())
{
custBean.setId(rs.getString(1));
custBean.setName(rs.getString(2));
custBean.setSource(rs.getString(3));
custBean.setCustServer(rs.getString(4));
custBean.setCustType(rs.getString(5));
custBean.setProvince(rs.getString(6));
custBean.setCity(rs.getString(7));
custBean.setRegion(rs.getString(8));
custBean.setAddress(rs.getString(9));
custBean.setTel(rs.getString(10));
custBean.setPhone(rs.getString(1));
custBean.setCarType(rs.getString(12));
custBean.setAlipay(rs.getString(13));
custBean.setTotal(rs.getString(14));
custBean.setCreateDate(rs.getString(15));
custBean.setLastCreateDate(rs.getString(16));
custBean.setRemark(rs.getString(17));
}
return custBean;
} catch (SQLException e) {
System.out.print("查询单个记录错误!");
e.printStackTrace();
} finally {
super.closeConnection();
}
return null;
}
// 实现修改
public int update(CustBean bea) {
String sql = "update cust set Name=?,Source=?,CustServer=?,CustType=?,Province=?,City=?,Region=?,Address=?,Tel=?,Phone=?,CarType=?,Alipay=?,LastCreateDate=?,Remark=? where id=?";
try {
PreparedStatement pstmt = super.getConnection().prepareStatement(sql);
pstmt.setString(1, bea.getName());
pstmt.setString(2, bea.getSource());
pstmt.setString(3, bea.getCustServer());
pstmt.setString(4, bea.getCustType());
pstmt.setString(5, bea.getProvince());
pstmt.setString(6, bea.getCity());
pstmt.setString(7, bea.getRegion());
pstmt.setString(8, bea.getAddress());
pstmt.setString(9, bea.getTel());
pstmt.setString(10, bea.getPhone());
pstmt.setString(11, bea.getCarType());
pstmt.setString(12, bea.getAlipay());
pstmt.setString(13, bea.getLastCreateDate());
pstmt.setString(14, bea.getRemark());
pstmt.setString(15, bea.getId());
int x = pstmt.executeUpdate();
return x;
} catch (SQLException e) {
System.out.print("修改方法错误!!!");
e.printStackTrace();
}finally{
super.closeConnection();
}
return 0;
}
}
发表评论
-
myeclipse10.0优化及SVN安装配置
2013-04-15 13:55 918myeclipse10.0优化及SVN安装配置 一、Mye ... -
生成一个Excel文件POI
2013-01-18 14:36 1164/** * 生成 ... -
Java中String中类的常用方法
2011-10-11 08:29 1089Java中String中类的常用方法 1) public ... -
把java文件打包成.jar (jar命令详解)
2011-06-15 09:19 2020把java文件打包成.jar ( ... -
myeclipse 生成JAR包并引入第三方包
2011-06-14 14:46 14700我用的是myeclipse8.0 首先用myeclipse生 ... -
java 创建XML文件
2010-11-16 14:04 1699public void changeXML() { ... -
Java文件下载的几种方式
2010-11-10 16:43 909Java文件下载的几种方式 public HttpServl ... -
StringUtils的isBlank与isEmply
2010-07-21 10:30 11901. public static boolean isEmpt ... -
web.xml配置404,500出错页面
2010-06-20 12:32 3285xml 页面 <!-- 400错误 --> ... -
JAVA读取TXT文件 可解决中文乱码问题
2010-04-28 21:18 12261import java.io.BufferedReader;i ... -
DAO类
2010-04-24 11:48 994最简单的DAO层数据库的连接与增、删、改、查 pack ... -
JAVA打成jar包
2010-03-13 16:43 9101、首先安装JDK 2、把MANIFEST.MF考到JDK的 ... -
JDK 配置
2010-03-10 14:48 1326JDK环境变量配置: 如果 ... -
调用google接口
2009-09-24 11:15 1465首先下载支持的jar http://google-api-tr ...
相关推荐
java连接mysqljava连接mysql
mysql-connector-java-bin-jar,java连接mysql库,适用java8
Java连接MySQL的jar -----> mysql-connector-java-5.1.7-bin.jar
java连接mysql的例子,网上搜集的。包括缩写的所有lib,jar包
java连接mysql5.5的jar包 mysql-connector-java-5.1.35-bin.jar
java连接mysql数据库用到的jar包
java连接mysql数据库需要的驱动包mysql-connector-java-8.0.17.jar,以及java连接mysql数据库的源码
Java 连接Mysql的驱动包,mysql-connector-java-5.1.22-bin.jar
简单java连接mysql数据库代码,包含读出
java 连接MYSQL源代码,包括MYSQL5的驱动
Java连接MySQL的jar依赖 ----> mysql-connector-java-8.0.20.jar
java连接mysql时需要使用到的驱动程序 也就是JDBC,Java数据库连接,(Java Database Connectivity,简称JDBC)是Java语言中用来规范客户端程序如何来访问数据库的应用程序接口,提供了诸如查询和更新数据库中数据的...
java连接mysql驱动。java连接mysql驱动。java连接mysql驱动。
Java连接MySql数据库,并且实现插入、删除、更新、选择操作.pdf
java连接mysql驱动 java连接mysql驱动 java连接mysql驱动
java连接mysql数据库必备驱动包,可以自定生成相应的实体类,同时也可以自动生相应的实体类格式的表结构
java 连接mysql 数据库 实现增删改查
Java连接Mysql数据库代码,可以直接连接数据库,返回数据表内的数据以及相关的内容。
通过java代码连接mysql数据库(JDBC),实现对数据库中表格的增删查改操作,同时增加了"注册"功能,内有java源代码和简单的PPT介绍,适用于初学数据库的人员。