连接数据库的语句有哪些

public static void main(String[] args) {

Connection conn = null

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")

String dburl ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}DBQ=D:\\project\\Core_Java\\db\\yxbdata.mdb"//此为NO-DSN方式

//String dburl ="jdbc:odbc:odbcName"//此为ODBC连接方式

conn = DriverManager.getConnection(dburl)

Statement stmt=conn.createStatement()

// stmt.executeUpdate("insert into class(classid,classname) values(4,'arthurs')")

// ResultSet rs=stmt.executeQuery("select Top 20 * from MobileSection")

ResultSet rs=stmt.executeQuery("select * from class")

while(rs.next()){

System.out.println(rs.getString("classId")+","+rs.getString("classname"))

}

} catch (Exception e) {

e.printStackTrace()

}finally{

try {

if(conn != null){

conn.close()

}

} catch (SQLException e) {

e.printStackTrace()

}

}

==========================

mysql

public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {

String text = ""

String url = "jdbc:mysql://localhost/test?user=root&password=root&useUnicode=true&characterEncoding=gbk"

Class.forName("org.gjt.mm.mysql.Driver").newInstance()

Connection conn = (Connection) DriverManager.getConnection(url)

Statement stmt = (Statement) conn.createStatement()

ResultSet rs = stmt.executeQuery("select * from hjx where id=26")

while(rs.next()){

text = rs.getString("text")

}

System.out.println(MysqlToMysql.changeYinHao(text))

conn.close()

}

==============================

mssql

public static void getText() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{

String url = "jdbc:microsoft:sqlserver://localhost:1433DatabaseName=成绩查询"

String name ="sa"String pwd = "sa"

// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance()

// Connection conn = (Connection) DriverManager.getConnection(url,name,pwd)

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")

Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433databasename=成绩查询","sa","sa")

conn.setAutoCommit(false)

Statement stmt = conn.createStatement()

// PreparedStatement stmt = (PreparedStatement) conn.prepareStatement("select top 10 * from employee")

ResultSet rs = stmt.executeQuery("select top 10 * from employee")

while(rs.next()){

System.out.println(rs.getString("name")+"-"+rs.getString("department"))

//log.debug(rs.getString("name")+"-"+rs.getString("Address"))

}

conn.commit()

}

public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {

ConnMSSql.getText()

}

sqlserver

，连接字符串是："server=.uid=sapwd=database=pubs"

第一个server：是指明你连接的服务器地址。如果是本机一般写。；如果是远程服务器，就写IP地址。

第二个uid：是登陆

数据库服务器

的用户名，我这里是用sa登陆的。

第三个pwd：是登陆数据库服务器的密码，因为我的密码是空，所以就不用写密码。

第四个database：是要连接的数据路的名字。

SqlConnection

con=new

SqlConnection("server=.uid=sapwd=database=pubs")