Home >Database >Mysql Tutorial >jdbc的连接例子

jdbc的连接例子

WBOY
WBOYOriginal
2016-06-07 15:13:321114browse

import java.sql.*; import java.util.*; public class Conn { private static String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver"; private String URL="jdbc:microsoft:sqlserver://10.254.100.149:1433;databasename=pubs"; //private String

import java.sql.*;
import java.util.*;

public class Conn {

private static String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";

private String URL="jdbc:microsoft:sqlserver://10.254.100.149:1433;databasename=pubs";

// private String URL="jdbc:microsoft:sqlserver://10.254.100.218:1433;databasename=weather_db";


private String USERNAME="sa";

private String PASSWORD="";

static {
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}

}

public Connection getConn() throws SQLException {
Connection con = null;
try {
con = DriverManager.getConnection(URL,USERNAME, PASSWORD);
} catch (SQLException e) {
throw e;
}
return con;
}

public void print() {
System.out.println("this is Connection!!!!!!!!!!!");
}

public static void main(String[] args) {

Conn conn = new Conn();
Statement st = null;
ResultSet rs = null;
try {
Connection con = conn.getConn();
st=con.createStatement();
rs=st.executeQuery("select * from sysusers");
System.out.println("########################################");
if (rs.next()) {
                String s=rs.getString(1);
                System.out.println(s);
            }else{
            System.out.println("nothing to use!!!!!!!!!!!");
            }
// System.out.println((String)rs.getObject(0));
// System.out.println(rs.getString(2));
System.out.println("########################################");
System.out.println("it is ok!!!!!!!!!");
} catch (SQLException ex) {
ex.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn