import java.sql.*;
import java.text.ParseException;
import java.util.Vector;
import javax.swing.*;
import javax.swing.table.AbstractTableModel;
public class OracleDB {
String USER_NAME, PASSWORD;//前台人员的登录名及其密码
private JTable table;
ResultSet rs;//数据库查询的结果集
private AbstractTableModel Tm;//表格模式管理器
private Vector<Vector<Object>> Vect = new Vector<Vector<Object>>();//用来显示该表从数据库得到信息的向量
Connection conn;
Statement stmt;
//卡级别表中用到的变量
static int myjibiehao;
static String mykajibie;
static String myzhekou;
public OracleDB () {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (Exception sqle) {
System.out.println("Exception:" + sqle);
}
}
//登录方法
public boolean landing(int a, String b) {
int myname;
String mypassword;
boolean m = false;
int i=1;
String p = "0";
String sql1 = "create table user (user_name varchar(20),password varchar(20))";
String sql2 = "insert into qiantairenyuan values('" + a + "','" + b + "')";
String sql3="select * from qiantairenyuan where USER_NAME='"+a+"' and PASSWORD='"+b+"'";
try {
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@211.87.224.23:1521:orcl",
"user201200131044", "123");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery(sql3);
//System.out.println("已连接数据库");
if(rset.next()){
myname = rset.getInt( "USER_NAME");
//System.out.println(myname);
mypassword = rset.getString("PASSWORD");
//System.out.println(mypassword);
return true;
}
rset.close();
stmt.close();
conn.close();
}
catch (Exception sqle) {
System.out.println("Exception:" + sqle);
return false;
}
return false;
}
//卡级别表的查询方法1
public ResultSet kajibie_chaxun(int a){
String sql2 = "insert into qiantairenyuan values('" + a + "','')";
String sql3="select * from kajibie where kajibiehao='"+a+"' ";
try {
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@211.87.224.23:1521:orcl",
"user201200131044", "123");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql3);
// rs.close();stmt.close();conn.close();
}
catch (Exception sqle) {
System.out.println("Exception:" + sqle);
}
return rs;
}
//卡级别表的查询方法2
public ResultSet kajibie_chaxun(String b){
String sql2 = "insert into qiantairenyuan values('" + b + "','')";
String sql3 = null;
if( new kajibie_panel().flag==1)
sql3="select * from kajibie where kajibie='"+b+"' ";
else
sql3="select * from kajibie where zhekou='"+b+"' ";
try {
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@211.87.224.23:1521:orcl",
"user201200131044", "123");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql3);
// rs.close();stmt.close();conn.close();
}
catch (Exception sqle) {
System.out.println("Exception:" + sqle);
}
return rs;
}
//房间信息表查询方法
public ResultSet fangjianxinxi_chaxun(int a){
// int i=0;int a=500;
String sql2 = "insert into fangjianxinxi values('" + a + "','"+2+"')";
String sql3="select * from fangjianxinxi where fangjianhao='"+a+"' ";
String sql4="select * from fangjianxinxi where fangjianleibiehao='"+a+"' ";
//String sql1 = "create table user_tmp (user_name varchar(20),password varchar(20))";
try {
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@211.87.224.23:1521:orcl",
"user201200131044", "123");
stmt = conn.createStatement();
if(a==1||a==2)
rs = stmt.executeQuery(sql4);
else
rs = stmt.executeQuery(sql3);
// rs.close();stmt.close();conn.close();
}
catch (Exception sqle) {
System.out.println("Exception:" + sqle);
}
return rs;
}
//客户表查询
public ResultSet kehu_chaxun(int a){
String sql3="select * from kehu where ruzhubianhao='"+a+"' ";
String sql4="select * from kehu where shenfenzhenghao='"+a+"' ";
String sql5="select * from kehu where lianxifangshi='"+a+"' ";
String sql6="select * from kehu where nianling='"+a+"' ";
String sql7="select * from kehu where KEHUJIBIEHAO='"+a+"' ";
String sql2="update kehu set shenfenzhenghao='"+a+"'";
try {
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@211.87.224.23:1521:orcl",
"user201200131044", "123");
stmt = conn.createStatement();
if(new kehu_panel().flag==9){
System.out.println(new kehu_panel().flag);
rs = stmt.executeQuery(sql3);}
else
if(new kehu_panel().flag==1){
rs = stmt.executeQuery(sql4);
}
else
if(new kehu_panel().flag==2){
rs = stmt.executeQuery(sql5);
}
else
if(new kehu_panel().flag==3){
rs = stmt.executeQuery(sql6);
System.out.println("年龄"+a);
}
else
if(new kehu_panel().flag==6){
rs = stmt.executeQuery(sql7);
}
}
catch (Exception sqle) {
System.out.println("Exception:" + sqle);
}
return rs;
}
//客户这个表的查询方法
public ResultSet kehu_chaxun(String b){
String sql8="select * from kehu where xinming='"+b+"' ";
String sql9="select * from kehu where jiatingzhuzhi='"+b+"' ";
String sql10="select * from kehu where xinbie='"+b+"' ";
try {
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@211.87.224.23:1521:orcl",
"user201200131044", "123");
stmt = conn.createStatement();
if(new kehu_panel().flag==4){
rs = stmt.executeQuery(sql8);}
else
if(new kehu_panel().flag==5){
rs = stmt.executeQuery(sql9);
}
else
if(new kehu_panel().flag==7){
rs = stmt.executeQuery(sql10);
}
else
if(new kehu_panel().flag==8){
rs = stmt.executeQuery(sql10);
}
}
catch (Exception sqle) {
System.out.println("Exception:" + sqle);
}
return rs;
}
//客户这个表的插入方法
public boolean kehu_charu(int a,int b,String c,String d,int e,int f,String g,int h,String i){
String sql1 = "insert into kehu values('" + a + "','"+b+"','"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"','"+i+"')";
try {
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@211.87.224.23:1521:orcl",
"user201200131044", "123");
stmt = conn.createStatement();
stmt.execute(sql1);
return true;
// rs.close();stmt.close();conn.close();
}
catch (Exception sqle) {
System.out.println("Exception:" + sqle);
}
return false;
}
//职工这个表的查询方法1
public ResultSet zhigong_chaxun(int a){
String sql3="select * from zhigong where ZHIGONGHAO='"+a+"' ";
String sql4="select * from zhigong where LIANXIFANGSHI='"+a+"' ";
String sql5="select * from zhigong where GONGLING='"+a+"' ";
//String sql6="select * from zhigong where nianling='"+a+"' ";
//String sql7="select * from zhigong where KEHUJIBIEHAO='"+a+"' ";
try {
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@211.87.224.23:1521:orcl",
"user201200131044", "123");
stmt = conn.createStatement();
if(new zhigong_panel().flag==0){
rs = stmt.executeQuery(sql3);}
else
if(new zhigong_panel().flag==1){
rs = stmt.executeQuery(sql4);
}
else
if(new zhigong_panel().flag==2){
rs = stmt.executeQuery(sql5);
}
// else
// if(new zhigong_panel().flag==3
疯狂java宾馆管理系统
需积分: 10 170 浏览量
2014-06-20
00:22:00
上传
评论
收藏 1.04MB RAR 举报
疯狂java宾馆管理系统 （107个子文件） 
OracleDB.class 15KB ruzhudengji_panel.class 9KB kehu_panel.class 7KB zhigong_panel.class 7KB fangjian_panel.class 6KB jiezhang_panel.class 6KB fangjianleixing_panel.class 6KB workframepanel.class 5KB kajibie_panel.class 5KB fangjianfuwu_panel.class 5KB kehujibie_panel.class 5KB fangjianxinxi_panel.class 5KB kehu_panel$5.class 4KB Login.class 4KB zhigong_panel$5.class 3KB ruzhudengji_panel$8.class 3KB TimePanel.class 3KB ruzhudengji_panel$9.class 3KB ruzhudengji_panel$7.class 3KB fangjian_panel$5.class 3KB fangjianxinxi_panel$3.class 3KB kehujibie_panel$3.class 3KB jiezhang_panel$1.class 2KB jiezhang_panel$2.class 2KB fangjianfuwu_panel$3.class 2KB kajibie_panel$5.class 2KB kehu_panel$6.class 2KB fangjianleixing_panel$4.class 2KB zhigong_panel$6.class 2KB Login$ButtonListener.class 2KB fangjianleixing_panel$1.class 2KB fangjianxinxi_panel$1.class 2KB fangjianfuwu_panel$1.class 2KB ruzhudengji_panel$6.class 2KB kehujibie_panel$1.class 2KB jiezhang_panel$5.class 2KB fangjian_panel$4.class 2KB zhigong_panel$1.class 2KB kajibie_panel$1.class 2KB kehu_panel$1.class 2KB ruzhudengji_panel$3.class 1KB jiezhang_panel$3.class 1KB ruzhudengji_panel$1.class 1KB ruzhudengji_panel$4.class 1KB TimePanel$2.class 1KB TimePanel$1.class 1KB fangjianleixing_panel$3.class 1KB fangjianfuwu_panel$2.class 1KB fangjianleixing_panel$2.class 1KB zhigong_panel$4.class 1KB fangjian_panel$1.class 1KB kehujibie_panel$2.class 1KB fangjian_panel$3.class 1KB zhigong_panel$3.class 1KB zhigong_panel$2.class 1KB fangjian_panel$2.class 1KB kehu_panel$2.class 1KB TimePanel$TimerActionListener.class 1004B fangjianxinxi_panel$2.class 922B kehu_panel$3.class 888B kehu_panel$4.class 888B workframepanel$12.class 881B kajibie_panel$2.class 876B workframepanel$10.class 862B kajibie_panel$3.class 860B workframepanel$9.class 860B workframepanel$7.class 860B workframepanel$2.class 860B workframepanel$1.class 860B workframepanel$3.class 860B workframepanel$6.class 860B workframepanel$4.class 860B workframepanel$5.class 860B workframepanel$8.class 860B kajibie_panel$4.class 858B workframepanel$11.class 811B ruzhudengji_panel$5.class 778B jiezhang_panel$4.class 760B TimePanel$3.class 694B ruzhudengji_panel$2.class 636B .classpath 554B OracleDB.java 25KB ruzhudengji_panel.java 19KB kehu_panel.java 12KB zhigong_panel.java 11KB jiezhang_panel.java 10KB workframepanel.java 8KB fangjianleixing_panel.java 8KB fangjian_panel.java 7KB kajibie_panel.java 6KB fangjianxinxi_panel.java 6KB kehujibie_panel.java 5KB fangjianfuwu_panel.java 5KB TimePanel.java 4KB Login.java 4KB
love1.jpg 96KB love1.jpg 96KB love2.jpg 49KB love2.jpg 49KB love.jpg 31KB共 107 条
- 1
- 2
资源评论
