📄 sqlmethod2.java
字号:
package shujuku;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.*;
public class SQLMethod2 {
public boolean b1=false;
public boolean b2=false;
public boolean b3=true;
public static int year;
public static int month;
public static int day;
public String[] str=new String[5];
public String searchS(String s1,String s2)
{
String dbUrl = "jdbc:odbc:db1";
String sa=null;
String user = "";
String password = "";
String[] str=new String[5];
str[2]=" ";
Statement s;
ResultSet results;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl, user, password);
s = c.createStatement();
String ss="SELECT * FROM 图书 WHERE BOOKID图书编号='"+s1+"'";
results=s.executeQuery(ss);
while(results.next())
{ b1=true;
String sas=jie(s2);
if(results.getString("BOOKSTAUS图书状态").equals("1")&&sas.equals(" "))
{ jieS(s2);
String srt="UPDATE 图书 set 图书状态='0' WHERE BOOKID图书编号='"+s1+"'";
results=s.executeQuery(srt);
c.close();
s.close();
results.close();
}
else if(sas.equals(" "))
{
str[0]="您要的图书已被借出";
str[1]=" ";
str[2]=str[0]+" "+str[1];
}
else
{str[0]="您的借书本数已经超出限制";
str[1]=" ";
str[2]=str[0]+" "+str[1];
}
}}
catch(Exception e)
{ // System.out.println("ERROR");
// System.out.println(e.getMessage());
}
return str[2];
}
public void searchI(String s2)
{
String dbUrl = "jdbc:odbc:db1";
String sa=null;
String user = "";
String password = "";
Statement s;
ResultSet results;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl, user, password);
s = c.createStatement();
results=s.executeQuery("SELECT * FROM 读者 WHERE READERID读者识别号='"+s2+"'");
while(results.next())
{
b2=true;
str[4]=results.getString("READERID读者识别号");
sa=results.getString("READERID读者识别号");
}
if(sa.equals("0"))
{
b3=false;
}
c.close();
s.close();
results.close();
}
catch(Exception e)
{
}
}
public String jie(String s2)
{ String add="无";
String dbUrl = "jdbc:odbc:db1";
String sa=null;
String user = "";
String password = "";
str[2]="";
Statement s;
ResultSet results;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl, user, password);
s = c.createStatement();
String sss="SELECT * FROM 读者 WHERE READERID读者识别号='"+s2+"'";
results=s.executeQuery(sss);
while(results.next())
{ if(!results.getString("借书本数").equals("0"))
{
add=" ";
}}
c.close();
s.close();
}
catch(Exception e)
{
// System.out.println(e.getMessage());
}
return add;
}
public void jieS(String s2)
{
String dbUrl = "jdbc:odbc:db1";
String sa=null;
String user = "";
String password = "";
str[2]="";
Statement s;
ResultSet results;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl, user, password);
s = c.createStatement();
String sss="UPDATE 读者 SET 借书本数='0' WHERE 读者识别号='"+s2+"'";
s.executeUpdate(sss);
c.close();
s.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
public boolean getB()
{
return b1;
}
public boolean getB3()
{
return b3;
}
public boolean getB1()
{
return b2;
}
public double getT()
{
double d=System.currentTimeMillis();
return d;
}
public void change(String s1,String s2,String s3)
{
String dbUrl = "jdbc:odbc:db1";
String user = "";
String password = "";
Statement s;
ResultSet results;
if(s1.equals("您要的图书已被借出"))
{
s1=" ";
s2=" ";
s3=" ";
}
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl, user, password);
s = c.createStatement();
String srt="UPDATE 图书访问记录 set 借阅图书号='"+s1+"',借阅者证号='"+s2+"',借书日期='"+s3+"'";
results=s.executeQuery(srt);
c.close();
s.close();
results.close();
}
catch(Exception e)
{
//System.out.println(e.getMessage());
}
}
public class getTime {
public getTime() {
Calendar todaysDate = new GregorianCalendar();
year = todaysDate.get(Calendar.YEAR);
month = todaysDate.get(Calendar.MONTH) + 1;
day = todaysDate.get(Calendar.DAY_OF_MONTH);
}
}
public String huan(String ss,String ss1)
{ String[] std=new String[5];
std[3]=" ";
String dbUrl = "jdbc:odbc:db1";
String user = "";
String password = "";
Statement s;
ResultSet results;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl, user, password);
s = c.createStatement();
String stt="SELECT*FROM 读者 WHERE READERID读者识别号='"+ss+"'";
results=s.executeQuery(stt);
while(results.next()){
std[0]=results.getString("读者识别号");
huanS(std[0]);
std[1]=results.getString("借阅图书1");
std[2]=results.getString("图书作者");
std[3]=std[0]+" "+std[1]+" "+std[2];
std[4]="UPDATE 读者 set 归还时间='"+ss1+"'WHERE 借阅图书号1='"+ss+"'";
s.executeQuery(std[4]);
}
c.close();
s.close();
results.close();
}
catch(Exception e)
{
// System.out.println(e.getMessage());
}
// System.out.println(std[3]);
return std[3];
}
public void huanS(String s2)
{
String dbUrl = "jdbc:odbc:db1";
String sa=null;
String user = "";
String password = "";
str[2]="";
Statement s;
ResultSet results;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl, user, password);
s = c.createStatement();
String sss="UPDATE 读者 SET 借书本数='1' WHERE 读者识别号='"+s2+"'";
s.executeUpdate(sss);
c.close();
s.close();
}
catch(Exception e)
{
// System.out.println(e.getMessage());
}
}
public void gai(String s1)
{
String dbUrl = "jdbc:odbc:db1";
String sa=null;
String user = "";
String password = "";
str[2]="";
Statement s;
ResultSet results;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl, user, password);
s = c.createStatement();
String ss="UPDATE 图书 SET BOOKSTAUS图书状态='1'WHERE BOOKID图书编号='"+s1+"'";
results=s.executeQuery(ss);
c.close();
s.close();
results.close();
}
catch(Exception e)
{
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -