sql嵌入式语言java实例_一个用java语言连接sql数据库例子，给自己做个备份，也希望能对大家有用。...

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class test

{

private String name;

private String password;

public String login()

{

Connection conn=null;

PreparedStatement ps=null;

ResultSet rs=null;

StringBuffer sql=new StringBuffer();

sql.append("select * from 表名 where name= ?");

sql.append(" and psw=?");

try {

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

conn=DriverManager.getConnection("jdbc:sqlserver://IP地址:1433;DatabaseName=数据库名","数据库用户名","数据库密码");

ps=conn.prepareStatement(sql.toString());

ps.setString(1, name);

ps.setString(2,password);

rs=ps.executeQuery();

if(rs!=null&&rs.next()){

return "success";

}

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

rs.close();

ps.close();

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

return "fail";

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

//

}