java – C# (Csharp) 프로그래밍

Java Build Path Error

이클립스 에러 Multiple annotations found at this line: – The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path 진행중인 프로젝트 에서 속성-> Project Facts 에서 자바 runtime 을 톰켓버전에 맞추어 체크 한다.

자바 디비 연결

JAVA

package javaDB;
import java.sql.*;
import com.microsoft.sqlserver.jdbc.*;

public class test {

public static void main(String[] args) {
		
		// Declare the JDBC objects.
		Connection con = null;
		CallableStatement cstmt = null;
		ResultSet rs = null;
		
		try {
			// Establish the connection. 
			SQLServerDataSource ds = new SQLServerDataSource();
			
			//ds.setIntegratedSecurity(true);
			ds.setServerName("localhost");
			ds.setPortNumber(1433); 
			ds.setDatabaseName("WSP_IBE");
			ds.setUser("user01");
			ds.setPassword("password01");
			con = ds.getConnection();
			 
	        	// Execute a stored procedure that returns some data.
            		cstmt = con.prepareCall("{call dbo.uspGetAircraft()}");
            		//cstmt.setInt(1, 50);
            		rs = cstmt.executeQuery();

	        	// Iterate through the data in the result set and display it.
	        	while (rs.next()) {
	            		System.out.println("aircraft_code: " + rs.getString("aircraft_code"));
	            		System.out.println("aircraft_english: " + rs.getString("aircraft_english"));
	            		System.out.println();
	        	}
	        }
	        
		// Handle any errors that may have occurred.
	    	catch (Exception e) {
	    		e.printStackTrace();
	    	}

	   	finally {
	    		if (rs != null) try { rs.close(); } catch(Exception e) {}
	    		if (cstmt != null) try { cstmt.close(); } catch(Exception e) {}
	    		if (con != null) try { con.close(); } catch(Exception e) {}
	    	}
	}
}

package javaDB;

import java.sql.*;

import com.microsoft.sqlserver.jdbc.*;

public class test {

public static void main(String[] args) {

// Declare the JDBC objects.

Connection con = null;

CallableStatement cstmt = null;

ResultSet rs = null;

try {

// Establish the connection.

SQLServerDataSource ds = new SQLServerDataSource();

//ds.setIntegratedSecurity(true);

ds.setServerName("localhost");

ds.setPortNumber(1433);

ds.setDatabaseName("WSP_IBE");

ds.setUser("user01");

ds.setPassword("password01");

con = ds.getConnection();

// Execute a stored procedure that returns some data.

cstmt = con.prepareCall("{call dbo.uspGetAircraft()}");

//cstmt.setInt(1, 50);

rs = cstmt.executeQuery();

// Iterate through the data in the result set and display it.

while (rs.next()) {

System.out.println("aircraft_code: " + rs.getString("aircraft_code"));

System.out.println("aircraft_english: " + rs.getString("aircraft_english"));

System.out.println();

}

// Handle any errors that may have occurred.

catch (Exception e) {

e.printStackTrace();

}

finally {

if (rs != null) try { rs.close(); } catch(Exception e) {}

if (cstmt != null) try { cstmt.close(); } catch(Exception e) {}

if (con != null) try { con.close(); } catch(Exception e) {}

}

JSP mysql

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %> 
 
<html> 
<head> 
<title>Connection with mysql database</title> 
</head> 
<body>
<h1>Connection status </h1>

<table>

<%
String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC"; 

Connection connection = null; 
PreparedStatement pstmt = null;
ResultSet rs = null;

try{
	Class.forName("com.mysql.jdbc.Driver").newInstance(); 
	connection = DriverManager.getConnection(connectionURL, "user02", "user99");
    
    String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ?";
    //String query ="SELECT airline_code,airline_korean FROM IBE.Airlines";
    
    pstmt = connection.prepareStatement(query); 
    pstmt.setString(1,"OZ");
       		
    rs = pstmt.executeQuery();
    
    while(rs.next()){	
    	String airline_code = rs.getString("airline_code");
    	String airline_korean = rs.getString("airline_korean"); 
%>
	 	<tr>
			<td width="100"><%=airline_code%></td>
			<td width="100"><%=airline_korean%></td>
		</tr>	
<%
    }
}
catch(Exception ex){
	out.println(ex.toString());
}finally{
	if(rs != null) try{rs.close();}catch(SQLException ex){}           
	if(pstmt != null) try{pstmt.close();}catch(SQLException ex){}   
	if(connection != null) try{connection.close();}catch(SQLException ex){}
}

%>

</table>

</body> 
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*" %>

<html>

<head>

<title>Connection with mysql database</title>

</head>

<body>

<h1>Connection status </h1>

<table>

String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC";

Connection connection = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try{

Class.forName("com.mysql.jdbc.Driver").newInstance();

connection = DriverManager.getConnection(connectionURL, "user02", "user99");

String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ?";

//String query ="SELECT airline_code,airline_korean FROM IBE.Airlines";

pstmt = connection.prepareStatement(query);

pstmt.setString(1,"OZ");

rs = pstmt.executeQuery();

while(rs.next()){

String airline_code = rs.getString("airline_code");

String airline_korean = rs.getString("airline_korean");

<tr>

</tr>

}

catch(Exception ex){

out.println(ex.toString());

}finally{

if(rs != null) try{rs.close();}catch(SQLException ex){}

if(pstmt != null) try{pstmt.close();}catch(SQLException ex){}

if(connection != null) try{connection.close();}catch(SQLException ex){}

}

</table>

</body>

</html>

jsp paramerer

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import = "java.sql.DriverManager" %>
<%@ page import = "java.sql.Connection" %>
<%@ page import = "java.sql.PreparedStatement" %>
<%@ page import = "java.sql.ResultSet" %>
<%@ page import = "java.sql.SQLException" %>

<%
String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC"; 

Connection connection = null; 
PreparedStatement pstmt = null;
ResultSet rs = null;

String code = request.getParameter("code"); //Code
if(code == null) code="";

String Decode = code;

try{
	if(code.length()==2){
		Class.forName("com.mysql.jdbc.Driver").newInstance(); 
		connection = DriverManager.getConnection(connectionURL, "user02", "user99");
	    
	    String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ? LIMIT 0, 1";
	    
	    pstmt = connection.prepareStatement(query); 
	    pstmt.setString(1,code);
	       		
	    rs = pstmt.executeQuery();
	    
		    while(rs.next()){
		    	Decode = rs.getString("airline_korean");
		    }
	   
		    out.println(Decode);
	   
    }else	
    	out.println(code);
	
}
catch(Exception ex){
	out.println(ex.toString());
}finally{
	if(rs != null) try{rs.close();}catch(SQLException ex){}           
	if(pstmt != null) try{pstmt.close();}catch(SQLException ex){}   
	if(connection != null) try{connection.close();}catch(SQLException ex){}
}
%>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%@ page import = "java.sql.DriverManager" %>

<%@ page import = "java.sql.Connection" %>

<%@ page import = "java.sql.PreparedStatement" %>

<%@ page import = "java.sql.ResultSet" %>

<%@ page import = "java.sql.SQLException" %>

String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC";

Connection connection = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

String code = request.getParameter("code"); //Code

if(code == null) code="";

String Decode = code;

try{

if(code.length()==2){

Class.forName("com.mysql.jdbc.Driver").newInstance();

connection = DriverManager.getConnection(connectionURL, "user02", "user99");

String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ? LIMIT 0, 1";

pstmt = connection.prepareStatement(query);

pstmt.setString(1,code);

rs = pstmt.executeQuery();

while(rs.next()){

Decode = rs.getString("airline_korean");

}

out.println(Decode);

}else

out.println(code);

}

catch(Exception ex){

out.println(ex.toString());

}finally{

if(rs != null) try{rs.close();}catch(SQLException ex){}

if(pstmt != null) try{pstmt.close();}catch(SQLException ex){}

if(connection != null) try{connection.close();}catch(SQLException ex){}

}

Java Programming Tutorial – 15 – Use Methods with Parameters

package apples;

import java.util.Scanner;
public class apples {
    public static void main(String[] args) {
		
		Scanner input = new Scanner(System.in);
		tuna tunaObject = new tuna();
		
		System.out.println("Enter your name here: ");
		String name  = input.nextLine();
		
		tunaObject.simpleMessage(name);
		}
}

//tuna.java
package apples;

public class tuna {
    public void simpleMessage(String name){
		System.out.println("Hello "+ name);
	}
}

package apples;

import java.util.Scanner;

public class apples {

public static void main(String[] args) {

Scanner input = new Scanner(System.in);

tuna tunaObject = new tuna();

System.out.println("Enter your name here: ");

String name = input.nextLine();

tunaObject.simpleMessage(name);

}

//tuna.java

package apples;

public class tuna {

public void simpleMessage(String name){

System.out.println("Hello "+ name);

}

Java Programming Tutorial – 14 – Using Multiple Classes

package apples;

public class apples {
    public static void main(String[] args) {
		tuna tunaObject = new tuna();
		tunaObject.simpleMessage();
		}
}

//tuna.java
package apples;

public class tuna {
    public void simpleMessage(){
		System.out.println("This is another class");
	}
}

package apples;

public class apples {

public static void main(String[] args) {

tuna tunaObject = new tuna();

tunaObject.simpleMessage();

}

//tuna.java

package apples;

public class tuna {

public void simpleMessage(){

System.out.println("This is another class");

}

Category Archives: java

Java Build Path Error

자바 디비 연결

Java Programming Tutorial – 15 – Use Methods with Parameters

Java Programming Tutorial – 14 – Using Multiple Classes

Java Programming Tutorial – 13 – While Loop

Java Programming Tutorial – 12 – Switch Statement

Java Programming Tutorial – 11 – Logical Operators

Java Programming Tutorial – 10 – If Statement

Java Programming Tutorial – 9 – Increment Operators

Java Programming Tutorial – 8 – Math Operators