import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
public class testdb {
public static String connect(String uid,String upass)
{
String reflag = "0";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");//要导入外部包
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1522:stuf1dbsid");//最后//一个是oracle的sid号
//stuf1dbsid sid号 scott/tiger登陆 sql为sql命令串 logondb为表 表有userid upass
// sql句子 为 select * from logindb where userid='uid' and upass='upass' ""不显示 ''才显示 ''是sql语句中框变量的
String sql="select * from login where sname='" + uid + "'and pass='" + upass+ "'";//定义
// result
PreparedStatement psmt= conn.prepareStatement(sql); //
ResultSet res = psmt.executeQuery();
//String a=res.getString(uid);
//System.out.println(a);
if(res.next())
{
reflag="1";
// System.out.println(res.getString(1));
// System.out.println(res.getString(2));
// res.getString(1);
// System.out.println("login ok");
//TestDia t= new TestDia(null);
//t.setVisible(true);
}else
{
System.out.println("login error");
}
} catch (ClassNotFoundException e1) {
// TODO 帺?惗惉 catch ?
System.out.println("login 2");
}
catch (SQLException e1) {
// TODO 帺?惗惉 catch ?
System.out.println("login 3");
}
return reflag;
}
public static String connectedb(String uname,int i )
{
String ret="";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1522:stuf1dbsid");
String sql="select * from T_USER where USERNAME='"+uname+"'";
PreparedStatement psmt= conn.prepareStatement(sql); //
ResultSet res = psmt.executeQuery();
if(res.next()){
ret=res.getString(i);
//if(uname!=res.getString(2)){
// JOptionPane.showMessageDialog(null, "查询失败"); }
}
else{
System.out.println("login 1");
//JOptionPane.showMessageDialog(null, "查询失败");
}
} catch (SQLException e) {
System.out.println("login 2");
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e1) {
System.out.println("login 3");
// TODO Auto-generated catch block
e1.printStackTrace();
}
return ret;
}
//
// public static void main(String[] args) {
//
//
//
//
//
//
// }
}