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
资源评论
