Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package testjdbc;
- import java.sql.Statement;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- public class sql_con {
- public static void main(String[] args) {
- Connection conn = null;
- String url = "jdbc:sqlserver://localhost:1433;databaseName=AbsentNotev2";
- String user = "sa";
- String pass = "123456";
- String query="select s.S_ID,s.SName,s.SPW,s.SMobileNumber,s.SEmail,scj.StartNumber,c.CName from Student s \n" +
- "join StudentClassJoin scj \n" +
- "on s.S_ID = scj.S_ID\n" +
- "join StartClass sc\n" +
- "on scj.StartNumber = sc.StartNumber\n" +
- "join class c\n" +
- "on sc.CNumber =c.CNumber\n" +
- "where s.S_ID = 'A123456789'" ;
- try {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- conn = DriverManager.getConnection(url,user,pass);
- if (conn != null && !conn.isClosed())
- {
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery(query);
- while(rs.next()){
- String name , cname, snumber,sid;
- name = rs.getString(1);
- cname=rs.getString(2);
- snumber=rs.getString(3);
- sid=rs.getString(4);
- System.out.println(name +" "+cname+" "+snumber+" "+sid);
- }
- }
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment