/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package com.shu;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author Samuel
*/
/*数据库操作类*/
public class Dao{
protected static String dbClassName = "com.mysql.jdbc.Driver";
//注意修改数据库名称
protected static String dbUrl = "jdbc:mysql://localhost:3306/hotel";
//数据库用户名保存在变量dbUser中
protected static String dbUser = "root";
//数据库密码保存在dbPwd中
protected static String dbPwd = "123456";
protected static String second = null;
private static Connection conn = null;
//Dao类的构造方法
private Dao() {
try {
if (conn == null) {
Class.forName(dbClassName);
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
} else {
return;
}
System.out.println("conn成功!");//控制台打印显示连接成功
} catch (Exception ee) {
ee.printStackTrace();
}
}
/*数据库查询方法
* 方法参数:sql查询语句
* 返回值:查询返回的结果集
*/
private static ResultSet executeQuery(String sql) {
try {
if (conn == null) {
new Dao();
}
//下面一行调用了Statement类的executeQuery(String sql)方法
//执行给定的 SQL 语句,该语句返回单个 ResultSet 对象,绝大多数是用SELECT语句
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
return null;
} finally {
}
}
/*数据库更新方法
* 方法参数:sql更新语句
* 返回值:一个整数,指示受影响的行数(即更新计数)
*/
private static int executeUpdate(String sql) {
try {
if (conn == null) {
new Dao();
}
//下面一行调用了Statement类中的executeUpdate方法
//用于执行 INSERT、UPDATE 或 DELETE 语句以及 SQL DDL(数据定义语言)语句
return conn.createStatement().executeUpdate(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
return -1;
} finally {
}
}
/**************************下面是针对当前项目定义的方法*************************************/
//查询信息
//验证成功
public static String chaXun(String name){
String sq1 = "select * from manage where name = '" + name + "'";
ResultSet rs = Dao.executeQuery(sq1);
String phoneGet = null;
try {
while(rs.next()){
String nameGet = rs.getString("name");
if(name.equals(nameGet)){
phoneGet = rs.getString("phone");
}else{}
}
} catch (SQLException ex) {
Logger.getLogger(Dao.class.getName()).log(Level.SEVERE, null, ex);
}
return phoneGet;
}
public static void xiugai(String name ,String phone){
String sq2 = "update manage set phone=" + phone + " where name=' "+ name + "'";
int rs = Dao.executeUpdate(sq2);
System.out.print(rs);
}
//删除name为”name“的信息
//试验成功
public static void shanChu(String name){
String sq3 = "delete from manage where name='" + name +"'";
Dao.executeUpdate(sq3);
}
public static void zengJia(String name , String phone){
String sq4 = "insert into manage (name,phone) values ('" + name + "',' " + phone +"')";
Dao.executeUpdate(sq4);
}
/************************记得关闭连接通道*************************************/
public static void close() {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn = null;
}
}
}
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package com.shu;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author Samuel
*/
/*数据库操作类*/
public class Dao{
protected static String dbClassName = "com.mysql.jdbc.Driver";
//注意修改数据库名称
protected static String dbUrl = "jdbc:mysql://localhost:3306/hotel";
//数据库用户名保存在变量dbUser中
protected static String dbUser = "root";
//数据库密码保存在dbPwd中
protected static String dbPwd = "123456";
protected static String second = null;
private static Connection conn = null;
//Dao类的构造方法
private Dao() {
try {
if (conn == null) {
Class.forName(dbClassName);
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
} else {
return;
}
System.out.println("conn成功!");//控制台打印显示连接成功
} catch (Exception ee) {
ee.printStackTrace();
}
}
/*数据库查询方法
* 方法参数:sql查询语句
* 返回值:查询返回的结果集
*/
private static ResultSet executeQuery(String sql) {
try {
if (conn == null) {
new Dao();
}
//下面一行调用了Statement类的executeQuery(String sql)方法
//执行给定的 SQL 语句,该语句返回单个 ResultSet 对象,绝大多数是用SELECT语句
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
return null;
} finally {
}
}
/*数据库更新方法
* 方法参数:sql更新语句
* 返回值:一个整数,指示受影响的行数(即更新计数)
*/
private static int executeUpdate(String sql) {
try {
if (conn == null) {
new Dao();
}
//下面一行调用了Statement类中的executeUpdate方法
//用于执行 INSERT、UPDATE 或 DELETE 语句以及 SQL DDL(数据定义语言)语句
return conn.createStatement().executeUpdate(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
return -1;
} finally {
}
}
/**************************下面是针对当前项目定义的方法*************************************/
//查询信息
//验证成功
public static String chaXun(String name){
String sq1 = "select * from manage where name = '" + name + "'";
ResultSet rs = Dao.executeQuery(sq1);
String phoneGet = null;
try {
while(rs.next()){
String nameGet = rs.getString("name");
if(name.equals(nameGet)){
phoneGet = rs.getString("phone");
}else{}
}
} catch (SQLException ex) {
Logger.getLogger(Dao.class.getName()).log(Level.SEVERE, null, ex);
}
return phoneGet;
}
public static void xiugai(String name ,String phone){
String sq2 = "update manage set phone=" + phone + " where name=' "+ name + "'";
int rs = Dao.executeUpdate(sq2);
System.out.print(rs);
}
//删除name为”name“的信息
//试验成功
public static void shanChu(String name){
String sq3 = "delete from manage where name='" + name +"'";
Dao.executeUpdate(sq3);
}
public static void zengJia(String name , String phone){
String sq4 = "insert into manage (name,phone) values ('" + name + "',' " + phone +"')";
Dao.executeUpdate(sq4);
}
/************************记得关闭连接通道*************************************/
public static void close() {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn = null;
}
}
}