package com.util;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBTest {
//查询
public static void testconnection(){
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/hunqing";
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.print("加载驱动失败");
e.printStackTrace();
}
try {
Connection conn=DriverManager.getConnection(url, "root", "123456");
System.out.println("加载驱动成功");
if(conn != null){
System.out.println("连接成功");
System.out.println("查询数据:");
String SQL = "select * from user";
Statement statement = conn.createStatement();
ResultSet resultset = statement.executeQuery(SQL);
while(resultset.next()){
int id = resultset.getInt("userId");
String name = resultset.getString("userName");
String Pw = resultset.getString("userPw");
System.out.print(id+",");
System.out.print(name+",");
System.out.println(Pw);
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//增加
public static void testconnection1(){
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/hunqing";
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.print("加载驱动失败");
e.printStackTrace();
}
try {
Connection conn=DriverManager.getConnection(url, "root", "123456");
System.out.println("加载驱动成功");
if(conn != null){
System.out.println("连接成功");
try {
System.out.println("添加数据:");
Statement statement = conn.createStatement();
String SQL = "insert into user(userName,userPw) values ('xiaozhou','123')";
int num = statement.executeUpdate(SQL);
System.out.println("成功插入" + num + "数据");
} catch (Exception e) {
System.out.println("添加数据失败");
}
System.out.println("查询数据:");
String SQL1 = "select * from user";
Statement statement1 = conn.createStatement();
ResultSet resultset1 = statement1.executeQuery(SQL1);
while(resultset1.next()){
int id = resultset1.getInt("userId");
String name = resultset1.getString("userName");
System.out.print(id+",");
System.out.println(name+",");
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//修改
public static void testconnection2(){
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/hunqing";
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.print("加载驱动失败");
e.printStackTrace();
}
try {
Connection conn=DriverManager.getConnection(url, "root", "123456");
System.out.println("加载驱动成功");
if(conn != null){
System.out.println("连接成功");
try {
System.out.print("修改数据:");
Statement statement = conn.createStatement();
String SQL = "UPDATE user SET userName = 'xiaoxiao' WHERE userId = 2";
statement.executeUpdate(SQL);
System.out.println("成功修改userId = 1数据");
statement.close();
} catch (Exception e) {
System.out.println("修改数据失败");
}
System.out.println("查询数据:");
String SQL1 = "select * from user";
Statement statement1 = conn.createStatement();
ResultSet resultset1 = statement1.executeQuery(SQL1);
while(resultset1.next()){
int id = resultset1.getInt("userId");
String name = resultset1.getString("userName");
System.out.print(id+",");
System.out.println(name+",");
}
resultset1.close();
statement1.close();
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//删除
public static void testconnection3(){
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/hunqing";
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.print("加载驱动失败");
e.printStackTrace();
}
try {
Connection conn=DriverManager.getConnection(url, "root", "123456");
System.out.println("加载驱动成功");
if(conn != null){
System.out.println("连接成功");
try {
System.out.print("删除数据:");
Statement statement = conn.createStatement();
String SQL = "delete from user WHERE userId = 1";
statement.executeUpdate(SQL);
System.out.println("成功删除userId = 1数据");
statement.close();
} catch (Exception e) {
System.out.println("删除数据失败");
}
System.out.println("查询数据:");
String SQL1 = "select * from user";
Statement statement1 = conn.createStatement();
ResultSet resultset1 = statement1.executeQuery(SQL1);
while(resultset1.next()){
int id = resultset1.getInt("userId");
String name = resultset1.getString("userName");
System.out.print(id+",");
System.out.println(name+",");
}
resultset1.close();
statement1.close();
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//登陆
public static void testconnection4(String name,String password){
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/hunqing";
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.print("加载驱动失败");
e.printStackTrace();
}
try {
Connection conn=DriverManager.getConnection(url, "root", "123456");
System.out.println("加载驱动成功");
if(conn != null){
System.out.println("连接成功");
System.out.println("查询数据:");
String SQL = "select * from user where userName =? and userPw=?";
PreparedStatement preparedstatement = conn.prepareStatement(SQL);
preparedstatement.setString(1,name);
preparedstatement.setString(2,password);
ResultSet resultset = preparedstatement.executeQuery();
while(resultset.next()){
name = resultset.getString("userName");
System.out.print("登陆成功");
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String [] args) {
testconnection4("xiaoxiao","222");
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
基于SSH的婚庆网站,适合新手,带数据库,数据库为MYSQL (251个子文件)
UserAction.class 6KB
DBTest.class 5KB
UserDaoImpl.class 4KB
ShangpinAction.class 4KB
SheyingAction.class 4KB
HunshaAction.class 4KB
HuncheAction.class 4KB
CehuaAction.class 4KB
ZhutiAction.class 4KB
upload.class 3KB
ShangpinDaoImpl.class 3KB
DingdanDaoImpl.class 3KB
SheyingDaoImpl.class 3KB
HuncheDaoImpl.class 3KB
HunshaDaoImpl.class 3KB
CehuaDaoImpl.class 3KB
ZhutiDaoImpl.class 3KB
User.class 3KB
HibernateSessionFactory.class 2KB
DingdanAction.class 2KB
Shangpin.class 2KB
Sheying.class 2KB
Hunche.class 2KB
Hunsha.class 2KB
Cehua.class 2KB
Zhuti.class 2KB
CharacterEncodingFilter.class 2KB
DBUtil.class 2KB
AdminDaoImpl.class 2KB
Dingdan.class 1KB
AdminAction.class 1KB
Admin.class 1KB
timeUtil.class 1KB
Test.class 959B
UserDao.class 702B
BaseDao.class 582B
BaseDao.class 580B
ShangpinDao.class 557B
SheyingDao.class 542B
DingdanDao.class 542B
HuncheDao.class 527B
HunshaDao.class 527B
CehuaDao.class 512B
ZhutiDao.class 512B
AdminDao.class 298B
.classpath 4KB
org.eclipse.wst.common.component 468B
org.eclipse.wst.jsdt.ui.superType.container 49B
common.css 13KB
mylessons.css 13KB
base.css 5KB
admin_login.css 4KB
main.css 3KB
css.css 1KB
hunche.css 207B
cehua.css 207B
hunsha.css 207B
sheying.css 207B
shangpin.css 207B
zhuti.css 184B
styles.css 84B
icomoon.eot 18KB
bg-about.gif 383B
bg-about-hover.gif 373B
admin-login-btnbg.gif 148B
index.html 3KB
hibernate3.jar 2.31MB
jbosscache-core-3.1.0.GA.jar 1.1MB
xwork-core-2.2.1.jar 997KB
freemarker-2.3.16.jar 860KB
struts2-core-2.2.1.jar 755KB
mysql-connector-java-5.1.7-bin.jar 693KB
jboss-cache-1.4.1.GA.jar 690KB
struts2-embeddedjsp-plugin-2.2.1.jar 662KB
c3p0-0.9.1.jar 594KB
javassist-3.9.0.GA.jar 583KB
commons-collections-3.2.jar 558KB
commons-collections-3.1.jar 546KB
javassist-3.7.ga.jar 531KB
mysql-connector-java-5.0.4-bin.jar 484KB
proxool-0.8.3.jar 465KB
antlr-2.7.6.jar 433KB
jstl-impl.jar 379KB
log4j-1.2.14.jar 359KB
dom4j-1.6.1.jar 307KB
hibernate-annotations.jar 273KB
cglib-2.2.jar 272KB
commons-lang-2.3.jar 240KB
ognl-3.0.jar 224KB
ehcache-1.2.3.jar 203KB
commons-beanutils-1.7.0.jar 184KB
commons-digester-2.0.jar 145KB
commons-validator-1.3.1.jar 136KB
json-lib-2.1-jdk15.jar 122KB
hibernate-entitymanager.jar 116KB
oscache-2.1.jar 112KB
commons-chain-1.2.jar 90KB
commons-io-1.3.2.jar 86KB
hibernate-commons-annotations.jar 65KB
struts2-convention-plugin-2.2.1.jar 64KB
共 251 条
- 1
- 2
- 3
资源评论
bingo丶
- 粉丝: 1w+
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功