conn.java

查询分析器java

import java.sql.*;
import java.net.URL;
public class Conn {
    Connection con=null;
    Statement stmt=null;
    //String name,pass,server,shenfen;
    LoginBean log=null;
    Conn(LoginBean log)
    {
        this.log=log;
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:"+log.getServer(),log.getUsername(),log.getPassword());
            stmt=con.createStatement();
            System.out.println("connect successful!");
            System.out.println(log.getUsername());
            /*String sql="select dname from dept where deptno=10";
            ResultSet rs=stmt.executeQuery(sql);
            while(rs.next())
            {
                System.out.println(rs.getString("dname"));
            }*/
        }catch(Exception ex)
        {
            System.out.println(ex.getMessage());
        }
    }
   /* public static void main(String[] args) {
        Conn conn = new Conn();
    }*/
}